How can I make the X axis temporally proportional?

I have a very simple line chart with decimal values on the Y axis and dates on the X axis. The dates are one per row in my source spreadsheet but they are not "evenly spaced". How can I make the chart reflect linear time, plotting the date categories irregulary along a smooth timeline?

Numbers '09-OTHER, OS X Mountain Lion (10.8.5)

Posted on Oct 5, 2013 11:30 AM

Reply
8 replies

Oct 6, 2013 12:07 AM in response to cbredesen

Hi c,


The Line chart (like most of the other chart types) is a Category chart, and spaces the categories evenly along the Category axis.


The only exception to the Category types is the Scatter Chart, in which both the X and Y axes are Value axes. As both previous posters have said, that's the type of chart to use for your desied result


One other difference to be aware of: For Category charts, the Categories are usually listed in a Header column, where Numbers can pick them up and automatically appply them as Category Labels; for a scatter chart, the values come in pairs, and both items in each pair must be in regular body columns.


Regards,

Barry

Oct 6, 2013 5:48 AM in response to cbredesen

Look forward to the real experts' comments on chart overlays.


As for date-format for X-axis it took some fiddling for me (sometimes it was greyed out) but it does work.


User uploaded file


Either leave it as Same as Source Data or pick Date and Time and choose one of the many formats available, some shorter than the source data format.


I haven't figured out how to make specific dates show up on the axis, e.g. in my example it would be nicer to show mid-month and/or month-end dates. Numbers seems to split into intervals based on the number of Steps, with little (no?) control over where intervals begin/end.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How can I make the X axis temporally proportional?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.