|Jul 31, 2012, 08:57 PM||#1|
Numbers charts - time in X axis
Hi. Often I'll want to chart values associated with certain dates in the future.
I discovered long ago that Excel has a nifty option to interpolate the data, so that time along the X axis is spread out evenly. Numbers seems to treat each date as just the next item, with no understanding of much time there is between it and the previous item.
So in Numbers, the chart looks the same no matter what the dates are. In Excel, the chart maps to the dates being properly allocated along the X axis.
Hard to explain - hopefully that's clear.
Am I missing a feature in Numbers? Can numbers chart values with dates, properly allocating the dates along the X axis?
|Jul 31, 2012, 09:22 PM||#2|
So it looks like a scatter plot will properly distribute dates along the x axis.
It's not quite what I want, though. I want a bar chart, with the bars properly distributed (especially since if there is more than one value on the same date, then they get added together).
Still, using the scatter plot is better than nothing.
|Thread Tools||Search this Thread|
|thread||Thread Starter||Forum||Replies||Last Post|
|URGENT: How to get x axis labels on Numbers?||sultanoflondon||Mac Applications and Mac App Store||4||Feb 12, 2014 02:20 PM|
|Are you able to make charts/graphs in Numbers beta?||MauerFan||Mac Applications and Mac App Store||9||Sep 20, 2013 11:33 AM|
|General: JellyLock vs Atom vs LockLauncher vs Axis||tymaster50||Jailbreaks and iOS Hacks||3||May 23, 2013 07:23 PM|
|iPhone: What's the difference between axis and grabby?||Samanosuke||Jailbreaks and iOS Hacks||9||May 14, 2013 12:27 PM|
|Axis in animation||AguaRas||iPhone/iPad Programming||3||Nov 28, 2012 12:33 AM|
All times are GMT -5. The time now is 09:43 PM.