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:
"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.
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!
"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.