Chart for hidden rows?


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!
 
Ad

Advertisements

A

Andy Pope

Hi,

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

Cheers
Andy
 
Ad

Advertisements

G

GSalisbury

Andy Pope said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top