I have charts that are only visible when selected, how do I fix?

G

Guest

I have charts on the worksheet, but they are covered in gray unless I select
the chart.
They also print in gray unless selected.

How do I get this formatting turned off?
 
A

Andy Pope

Hi,

Use Tools > Options > View and change the setting of Objects to Show All
instead of Show Placeholders.

Cheers
Andy
 
G

Guest

Thanks Andy, it worked like a charm.

Tony

Andy Pope said:
Hi,

Use Tools > Options > View and change the setting of Objects to Show All
instead of Show Placeholders.

Cheers
Andy
Click to expand...
 

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

Similar Threads

Charts graying out 2
Chart Area visible but cannot access rows and columns on worksheet 2
How do I make Excel 2007 chart sheets visible 1
washed out charts 3
Inside Base Series Label Showing #N/A 0
Excel 2007 problem with bar charts 1
Pie charts - 0 values 2
how to select multiple charts on a worksheet in excel 2007 1

Top