software

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 gt; Options gt; View and change the setting of Objects to Show All
instead of Show Placeholders.

Cheers
Andy

Tony Parks wrote:
gt; I have charts on the worksheet, but they are covered in gray unless I select
gt; the chart.
gt; They also print in gray unless selected.
gt;
gt; How do I get this formatting turned off?

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Thanks Andy, it worked like a charm.

Tony

quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; Use Tools gt; Options gt; View and change the setting of Objects to Show All
gt; instead of Show Placeholders.
gt;
gt; Cheers
gt; Andy
gt;
gt; Tony Parks wrote:
gt; gt; I have charts on the worksheet, but they are covered in gray unless I select
gt; gt; the chart.
gt; gt; They also print in gray unless selected.
gt; gt;
gt; gt; How do I get this formatting turned off?
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;