Skip navigation

how do I update the chart axis values??

306 Views 3 Replies Latest reply: Jan 22, 2013 11:11 AM by Jerrold Green1 RSS
hulkster081 Calculating status...
Currently Being Moderated
Jan 22, 2013 6:42 AM

I created a Gantt (bar chart) chart in Numbers for a project at work showing schedules.  It looked fine, and everything worked great.  I want to use that same chart, but I want to just update the data in it.  I can get the bars to change, but the Y axis data (not the numbered values in the chart, but rather the the actual names out to the side of the chart) will not change.  For instance....

 

Name
Start DateFinish
Task 1

January 1, 2013

January 15, 2013
Task 2February 1, 2013February 15, 2013

 

 

The Tasks on the left will be the Y axis fields in a bar chart....and the dates will populate the graph.  I've created my graph from this data and got it like I want it.  Now let's say I want to simply change some things in the Name column:

 

NameStart DateFinish
New TaskJanuary 1, 2013January 15, 2013
Task 4February 1, 2013February 15, 2013

 

So without creating a new chart or anything, I just want to reflect the new names in my existing chart.  In Excel, when you change the value data, it updates the chart and "it just works" .  I'm wanting to use Numbers for this, and I feel like this is a simple thing that I'm just missing.  Help!

MacBook Air (13-inch, Mid 2012), OS X Mountain Lion (10.8.2)
  • Jerrold Green1 Level 7 Level 7 (28,205 points)
    Currently Being Moderated
    Jan 22, 2013 8:48 AM (in response to hulkster081)

    HS,

     

    When speaking about a Bar Chart, there are no X and Y axes, only Category Axis and Value Axis.

     

    The Category labels are simply whatever you have in the category column of your table's Chart Range. To change what is there, edit it.

     

    It would be difficult to be more specific without knowing how you made that chart. There is no direct way to make a Chart like that in Numbers since Dates aren't allowed as Values. We would normally use week-number instead, where week-number is a numeric representation of the time elapsed since some base date.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,205 points)
    Currently Being Moderated
    Jan 22, 2013 11:11 AM (in response to hulkster081)

    Numbers Category Charts are happiest when the Category Axis data column is a Header Column or Row. It's difficult to coerce a Category chart to use the labels in a non-Header category field. Header Column/Rows are formatted as Text by default.

     

    Conversely, it's difficult to get a Numbers Scatter Chart to take X-values from a Header column. You get the picture - plan ahead.

     

    Jerry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.