Legend

#1 06-17-2005, 08:05 AM

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

#2 06-17-2005, 09:05 AM

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?

#3 06-17-2005, 12:05 PM

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

#4 06-17-2005, 08:05 PM

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)