Currently Being ModeratedDec 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.
Currently Being ModeratedDec 7, 2012 4:19 PM (in response to Jerrold Green1)
THanks - I'm embarrassed to say I was actually using the wrong button - going to the top chart menu rather than using the chart button in the tools menu first. When I figured that out, it worked. Also, I know they say that about header rows and columns, but I have never designated header rows and columns and the charts always label correctly for me. Perhaps the default is for charts to assume that the top row and leftmost column is a header...
Thank you for taking the time to respond.
Currently Being ModeratedDec 7, 2012 10:03 PM (in response to KGE33)
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.