Chart for hidden rows?

  • Thread starter Thread starter FARAZ QURESHI
  • Start date Start date
F

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!
 
Hi,

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

Cheers
Andy
 
Andy Pope said:
Hi,

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

Cheers
Andy
Click to expand...

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.
 
Back
Top