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?