Microsoft Office Tutorials and References
In Depth Information
If you don’t want a particular embedded chart to appear on your printout,
rightclick the chart and choose Format Chart Area from the shortcut menu. Click the
Properties tab in the Format Chart Area dialog box and remove the check mark
from the Print Object check box.
If you created the chart on a Chart sheet, Excel prints the chart on a page by
itself. If you open Excel’s Page Setup dialog box when the chart sheet is active, the
Sheet tab is replaced with a tab named Chart. Figure 1-19 shows the Chart tab of
the Page Setup dialog box, which has several options.
Use full page: Excel prints the chart to the full width and height of the
page margins. This usually isn’t a good choice because the chart’s relative
proportions change and you lose the WYSIWYG advantage.
Scale to fit page: Expands the chart proportionally in both dimensions
until one dimension fills the space between the margins. In other words,
the aspect ratio of the chart is maintained. This option usually results in
the best printout.
with Window to make the chart correspond to the window size and
proportions. The chart prints at the current window size and proportions.
Custom: Prints the chart as it appears on your screen. Select View
The Printing quality options work just like those for worksheet pages. If you
choose the Draft quality option for a chart sheet, Excel prints the chart, but its
quality may not be high (the actual effect depends on your printer). Choosing the Print
in Black and White option prints the data series with black-and-white patterns
rather than colors. Most noncolor printers handle this fine, even if this option is not
set. But you might want to experiment to determine the best output quality for your
Figure 1-19: The Chart tab of the Page Setup