Currently Being ModeratedSep 5, 2012 7:02 AM (in response to pef105)
First let's see if you have the chart set up correctly. Here is how I set up a chart with dates:
make a table where the first column is filled with valid dates and the second column are values to graph.
Make the first row a header.
now enter names for the columnsm then select the DATA of the graph (that is... do NOT include the header row).
while the data is selected choose the bar graph from the Chart tool.
You should get somethign that looks like:
You may want to sort the data in the chart (by date)
now select the chart and open the "Chart Inspector":
Now change the auto setting for "Label every" from auto to "1". To make the dates readable you can select the dates by clicking on on (just below the chart) then change the angle of the X-axis labels to 90:
Here is the chart after changing the angle to 90:
Currently Being ModeratedSep 7, 2012 8:08 PM (in response to pef105)
Make sure that you are entering the min and max dates correctly. The upper box is Max and the lower box is Min. It's the opposite of the way we usually think of entering it.
What you describe sounds like you're entering in the wrong boxes.
Currently Being ModeratedSep 7, 2012 9:34 PM (in response to pef105)
"I have a scatter chart in which the x-axis is dates."
I'd say Jerry's made the correct diagnosis. Here's my result with a scatter chart setting both minimum (Jan1) and maximum (Mar 30) outside the limits of the actual 'data'. Settings I used are shown in the inspector pane to right. Missing is the setting of 80° rotation of the x-axis labels, doen in the Metrics pane (ruler) of the inspector.
Note also that the date values for a scatter chart must be in an non-header column. In a Category chart, such as the bar chart in Wayne's example, the category names (eg. dates) must be in a header column to be applied to the chart.
Currently Being ModeratedSep 12, 2012 7:27 AM (in response to pef105)
Many thanks for you responses. However the chart is set up correctly, and I did notice that Max is above Min in the inspector.
Here's what happens:
Here is the chart with the inspector open before I enter a new minimum.
Here is the chart with the new minimum entered, and it's looking good:
Now here's what happens when I close the inspector. All I have done between the above screenshot and the one below is click on the red button on the inspector to close it.
As you can see the minimum has suddenly been arbitrarily changed.
Now I have discovered a workaround which corrects this. That is to now choose "Undo" in the Edit menu and, voila, the desired minimum is back.
The above is the simplest of the strange behaviors. If one changes both the minimum and the maximum it gets stranger still, and if one keeps on trying to correct things by again and again applying the desired minimum and maximum via the inspector (without doing the Undo trick) one eventually gets a chart with the x-axis as a single date, i.e. the minimum and maximum are identical.
I'm happy now that I know how to get what I want, but Apple needs to look into this!
Currently Being ModeratedSep 12, 2012 8:33 AM (in response to pef105)
"I'm happy now that I know how to get what I want, but Apple needs to look into this!"
To let Apple know about this issue, use the Feedback channel.
In Numbers, go to the Application menu (labeled "Numbers") and choose Provide Numbers Feedback. Choose to file a Bug Report, describe the issue, and the steps necessary to trigger its occurrence and steps you found to correct it.
Currently Being ModeratedNov 18, 2012 8:28 PM (in response to Barry)
Hi folks. Joining this thread late.
I can't get a scatter chart to work using Date as the X Axis. Columns I have:
I want Date as X, and Running as Y. How can I fix this?
Currently Being ModeratedNov 19, 2012 5:23 AM (in response to BioRich)
Better to post this to a new thread as your questions is similar but different AND you didn't show what the problem is.
Currently Being ModeratedNov 19, 2012 5:31 AM (in response to Wayne Contello)
OK, I will post to a new thread. The problem is that it didn't work. There is no date x axis at all. It's so not working, it didn't work one bit. The problem is that it's so complex, that it didn't come close to demonstrating what isn't working. By definition, the application isn't working.