ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Microsoft Office Application Help - Excel Help forum > Excel Programming > Excel Charting

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 06-17-2005, 08:05 AM
Alison
Guest
 
Posts: n/a
Legend

Is it possible to set up the Legend so that it only shows when it is in
prited format?
Reply With Quote
  #2  
Old 06-17-2005, 09:05 AM
Jerry W. Lewis
Guest
 
Posts: n/a
Re: Legend

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?


Reply With Quote
  #3  
Old 06-17-2005, 12:05 PM
Andy Pope
Guest
 
Posts: n/a
Re: Legend

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
Reply With Quote
  #4  
Old 06-17-2005, 08:05 PM
Jon Peltier
Guest
 
Posts: n/a
Re: Legend

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?

>
>

Reply With Quote
Reply

Bookmarks

New topics in Excel Charting


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

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump


All times are GMT -4. The time now is 09:17 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0