Skip navigation

chart function worked, then grayed out

394 Views 4 Replies Latest reply: Dec 7, 2012 10:03 PM by Barry RSS
KGE33 Calculating status...
Currently Being Moderated
Dec 7, 2012 9:00 AM

I have a spreadsheet with about 800 rows and analyzing text data using countifs.  I've already done a bunch of charts this way, just tried one and got a nice stacked column chart but it did not have the axes labeled. I looked at the way I had done previous charts and then included the axis titles in the range I selected to make the chart. Now ALL my chart functions are grayed out and I cannot make a chart!! I cannot even make a chart with a simple selection of table number values without the axis labels.  What is going on??

Mac Pro, Mac OS X (10.6.8)
  • Jerrold Green1 Level 7 Level 7 (28,175 points)
    Currently Being Moderated
    Dec 7, 2012 11:15 AM (in response to KGE33)

    The Category Axis must be a Header Row or Header Column for the Category (Non-Value-Axis) to display properly.

     

    Without a screen shot of your situation it's difficult to say what the problem may be with the options being grayed out.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,175 points)
    Currently Being Moderated
    Dec 7, 2012 7:07 PM (in response to KGE33)

    KG,

     

    I believe that your default Table probalby does have 1 Header Row and 1 Header Column, so you would be safe in that assumption.

     

    Glad you got it figured out.

     

    Jerry

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Dec 7, 2012 10:03 PM (in response to KGE33)

    Hi KG,

     

    The default behavioour is for the 'Blank' templates to produce a document with a single sheet, containing a single table. The table has one header row and one header column.

     

    The charts don't assume anything regarding the top row or left column of the selected range.

     

    If the left column is a Header column, then the chart is able to, and will use the entries in that column as labels.If it is not a Header column, the chart will not use those entries as labels. The case for the top row is similar. No assumption is involved in either case.

     

    Regards,

    Barry

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.