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

Chart for hidden rows?
 

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

Chart for hidden rows?
 

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

Chart for hidden rows?
 

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


"Andy Pope" wrote:

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