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? |
All times are GMT +1. The time now is 01:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com