Chart blank/reference cells row height 0.00

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brenda - 25 Nov 2003 19:39 GMT

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

Reply to this Message

Debra Dalgleish - 25 Nov 2003 20:12 GMT

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

> 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?

Signature

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

Reply to this Message

Brenda - 25 Nov 2003 21:01 GMT

Thanks! Sometimes I miss the obvious...

Brenda

>-----Original Message-----
>1. Select the chart
[quoted text clipped - 6 lines]
>> way to do this without making the chart go blank? Why
>> would this make the chart go blank to begin with?

Reply to this Message