Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Jul 31, 2012, 08:57 PM   #1
Undecided
macrumors 6502a
 
Join Date: Mar 2005
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?
Undecided is offline   0 Reply With Quote
Old Jul 31, 2012, 09:22 PM   #2
Undecided
Thread Starter
macrumors 6502a
 
Join Date: Mar 2005
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.
Undecided is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
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

Forum Jump

All times are GMT -5. The time now is 10:01 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC