Chart for hidden rows?

[FARAZ QURESHI]

I am feeling some trouble!

I have a Bar Graph based on a data table based on Subtotals & Grouping!
Whenever the first level of Grand Total is selected the chart's bars vanish!

Any idea how to overcome this problem.

Thanx in advance!

 

[Andy Pope]

Hi,

Select the chart and then use the menus
Tools > Options > Chart
Uncheck 'Plot visible cells only'

Cheers
Andy

 

[GSalisbury]

Hi,

Select the chart and then use the menus
Tools > Options > Chart
Uncheck 'Plot visible cells only'

Cheers
Andy

Thank you - I, too, had a chart using what would ordinarily have been a
hidden column.
I'm new to charting so, not stopping to look, took the "easier?" way out -
white font color and shrunken column width.
This is much better.
Geo. S.