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" wrote in message
...
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