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.

 

[dobie]

I have rows not showing in a spread sheet. I tried the HELP suggestion, same
as yours (TOOLS, OPTIONS) but the "Plot visible cells only" check box isn't
checked. Where are my missing rows? How do I find them?
--
dobiegillis

Hi,

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

Cheers
Andy