Thread: Legend

Is it possible to set up the Legend so that it only shows when it is in
prited format?

Not directly, but you could remove the legend from the chart and write a
VBA macro for the Workbook_BeforePrint event that would set the chart's
..HasLegend property to True if the chart is part of what is to be printed.

Jerry

Alison wrote:

> Is it possible to set up the Legend so that it only shows when it is in
> prited format?

Hi,

For a non vba solution how about covering the legend with an autoshape.
Format this to has the same colour as the chart area without a border.
Set the properties of the autoshape to not print, so legend is covered
in worksheet but revealed when printed.

Cheers
Andy

Alison wrote:
> Is it possible to set up the Legend so that it only shows when it is in
> prited format?

--

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

I like that one.

- Jon

Andy Pope wrote:

> Hi,
>
> For a non vba solution how about covering the legend with an autoshape.
> Format this to has the same colour as the chart area without a border.
> Set the properties of the autoshape to not print, so legend is covered
> in worksheet but revealed when printed.
>
> Cheers
> Andy
>
> Alison wrote:
>
>> Is it possible to set up the Legend so that it only shows when it is
>> in prited format?
>
>