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.
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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
