3 Replies Latest reply: Jan 22, 2013 11:11 AM by Jerrold Green1
hulkster081 Level 1 Level 1 (0 points)

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 (29,935 points)

    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

  • hulkster081 Level 1 Level 1 (0 points)

    Jerrold....thanks for the reply.  While you didn't answer my question exactly (I know I was a bit vague), you did put me on the right path.  I was trying to get the Category Axis values to change on the chart whenever I updated them in the table itself.  I couldn't figure out why they weren't but I think I have now. 

     

    I noticed that in the Category Axis field (Inspector) it had the actual typed names of my tasks from the table instead of the cell locations.  So...."Task 1" instead of "Table 1: C7".  I cleared out all of the text in the Category Axis field, which removed it from the chart.  then I just clicked on the fields in the table and it populated the Category Axis blank with the table/cell info instead of the text.  So now when I update one of the fields, it updates the chart because it's pulling from the cell data every time.

     

    I'm not really sure why Number, by default, enters the text into the Category Axis when making a chart instead of putting in the corresponding cell locations, but whatever.  I got it working now and should be good to go going forward, thanks for your help.

  • Jerrold Green1 Level 7 Level 7 (29,935 points)

    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