A
Alison
Is it possible to set up the Legend so that it only shows when it is in
prited format?
prited format?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jerry W. Lewis
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
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
A
Andy Pope
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
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
J
Jon Peltier
I like that one.
- Jon
- Jon
Andy said: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