Numbers charts - time in X axis

Discussion in 'Mac Apps and Mac App Store' started by Undecided, Jul 31, 2012.

  1. Undecided
    Expand Collapse
    macrumors 6502a

    Mar 4, 2005
    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?
  2. Undecided
    Expand Collapse
    thread starter macrumors 6502a

    Mar 4, 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.

Share This Page