8 Replies Latest reply: Nov 19, 2012 5:31 AM by BioRich
pef105 Level 1 Level 1 (0 points)

I have a scatter chart in which the x-axis is dates.  When I first set up the chart everything works, but when I try to change the x-axis minimum or maximum, Numbers seems to go haywire. When the chart is first set up the inspector shows the x-axis minimum and maximum as "auto". If I then try to enter a new x-axis minimum (starting date), as soon as I click in another box in the inspector, Numbers arbitrarily changes the date I have just entered.  I have occasionally been able to extend the chart by changing (increasing) the x-axis maximum, but then if I try to change the minimum, the maximum suddenly changes to equal the minimum and I get a chart with the same date across the x-axis.  There seems to be no rhyme or reason for the way Numbers changes things.  Occasionally I have managed to change both dates in the way that I want and the chart looks good, only to have Numbers do the arbitrary changes when I close the inspector.  I would really like to quit using Excel, but as long as Numbers plays these games that day will never come.  Any help would be appreciated!  Thanks.

  • 1. Re: Why won't Numbers allow me to reset the maximum or minimum on a date-based x-axis?
    Wayne Contello Level 6 Level 6 (13,620 points)

    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:

    Screen Shot 2012-09-05 at 8.56.25 AM.png

     

    You may want to sort the data in the chart (by date)

    now select the chart and open the "Chart Inspector":

     

     

    Screen Shot 2012-09-05 at 8.58.24 AM.png

     

    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:

    Screen Shot 2012-09-05 at 9.00.22 AM.png

     

    Here is the chart after changing the angle to 90:

    Screen Shot 2012-09-05 at 9.01.41 AM.png

  • 2. Re: Why won't Numbers allow me to reset the maximum or minimum on a date-based x-axis?
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    PEF,

     

    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.

     

    Jerry

  • 3. Re: Why won't Numbers allow me to reset the maximum or minimum on a date-based x-axis?
    Barry Level 7 Level 7 (29,180 points)

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

    Picture 3.png

    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.

     

    Regards,

    Barry

  • 4. Re: Why won't Numbers allow me to reset the maximum or minimum on a date-based x-axis?
    pef105 Level 1 Level 1 (0 points)

    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.

    Screen Shot 2012-09-12 at 10.00.54 AM.png

    Here is the chart with the new minimum entered, and it's looking good:

    Screen Shot 2012-09-12 at 10.01.28 AM.png

     

    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.

     

    Screen Shot 2012-09-12 at 10.01.45 AM.png

     

    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.

     

    Screen Shot 2012-09-12 at 10.02.03 AM.png

     

    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!

  • 5. Re: Why won't Numbers allow me to reset the maximum or minimum on a date-based x-axis?
    Barry Level 7 Level 7 (29,180 points)

    "I'm happy now that I know how to get what I want, but Apple needs to look into this!"

     

    Hi PER,

     

    If you want Apple to know about this and look into it, you'll need to talk to Apple, Here, your audience consists of Numbers users like yourself. Apple does not regularly monitor these forums (except for compliance with the terms of use).

     

    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.

     

    Regards,

    Barry

  • 6. Re: Why won't Numbers allow me to reset the maximum or minimum on a date-based x-axis?
    BioRich Level 1 Level 1 (65 points)

    Hi folks. Joining this thread late.

     

    I can't get a scatter chart to work using Date as the X Axis.  Columns I have:

     

    Date

    Transaction

    Amount

    Running

     

    I want Date as X, and Running as Y.  How can I fix this?

     

    Cheers

  • 7. Re: Why won't Numbers allow me to reset the maximum or minimum on a date-based x-axis?
    Wayne Contello Level 6 Level 6 (13,620 points)

    Better to post this to a new thread as your questions is similar but different AND you didn't show what the problem is.

  • 8. Re: Why won't Numbers allow me to reset the maximum or minimum on a date-based x-axis?
    BioRich Level 1 Level 1 (65 points)

    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.