XL2002: Scatter Chart Series Lines and Trendlines Are Not Printed Correctly

When you print a scatter chart, the data series and trendline may appear to have moved from their original location.

This problem occurs in both the printed chart, and print preview.

This problem can occur when you print to some printers if all of the following conditions are true:

• You are using one of the printers listed below and the resolution is greater than 300 dots per inch (dpi).
• You create an XY Scatter Chart with lines connecting the scatter points.
• You add a trendline to the chart and you base the trendline on a data range larger than the data range that you used to create the chart.

The problem can occur with the following printers: The problem does not occur with all charts, or with all printers.

To resolve this issue, use one of the following methods.

Method 1

When you create a chart from a data range, make the chart from only the data which you intend to print.

Method 2

Increase the data range of the printed chart so that it includes all of the data that is in the chart from which the trendline was created.

Method 3

Use a different printer.

Method 4

Reduce the resolution of the printer to 300 dpi.

To reduce the resolution of a printer, follow these steps:

1. In Excel, click Print on the File menu.
2. In the Print dialog box, click Properties.
3. On the Graphics tab, click inside the Resolution box.
4. Click 300 dpi, and then click OK.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.