Chart blank/reference cells row height 0.00

[Brenda]

When I "hide" the reference cells by making their row
height 0.00, the chart blanks out. Is there any other
way to do this without making the chart go blank? Why
would this make the chart go blank to begin with?

TIA,
Brenda

 

[Debra Dalgleish]

1. Select the chart
2. Choose Tools>Options, Chart tab
3. Remove the check mark from 'Plot visible cells only'
4. Click OK

 

[Brenda]

Thanks! Sometimes I miss the obvious...

Brenda

-----Original Message-----
1. Select the chart
2. Choose Tools>Options, Chart tab
3. Remove the check mark from 'Plot visible cells only'
4. Click OK




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.