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

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?

Hi,

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

Cheers
Andy

Tony Parks wrote:
> 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?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks Andy, it worked like a charm.

Tony

"Andy Pope" wrote:

> Hi,
>
> Use Tools > Options > View and change the setting of Objects to Show All
> instead of Show Placeholders.
>
> Cheers
> Andy
>
> Tony Parks wrote:
> > 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?
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>