Chart for hidden rows?

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!

--

Best Regards,
FARAZ A. QURESHI

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"FARAZ QURESHI" <FARAZQURESHI@discussions.microsoft.com> wrote in message
news:F8FD6941-778C-40B2-8A5D-7D9E9D708D4C@microsoft.com...
>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!
>
> --
>
> Best Regards,
> FARAZ A. QURESHI

"Andy Pope" <andy@andypope.info> wrote in message
news:265A6488-ACEE-441B-8296-78EF1A5930B3@microsoft.com...
> 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.