Microsoft KB Archive/923873

= A data series border in a chart may overlap more in Excel 2007 than in an earlier version of Microsoft Excel =

Article ID: 923873

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Excel 2007

-





SYMPTOMS
In Microsoft Office Excel 2007, when you change the line style width of a data series in a chart, the border width of the data series may be wider than expected. Additionally, the data series border may overlap another data series border more in Excel 2007 than in an earlier version of Microsoft Excel.



CAUSE
This behavior may occur if the data series shares the border space with an adjoining data series. This behavior may occur in a column-type or bar-type chart.



WORKAROUND
To work around this behavior, use one of the following methods.

Method 1: Use a smaller line style width
To change the line style width for the data series, follow these steps:
 * 1) Right-click the data series, and then click Format Data Series.
 * 2) Click Line Style.
 * 3) In the Width box, enter a smaller point size, and then click Close.

Method 2: Reset the data series
To reset the data series, right-click the data series in the Excel 2007 chart, and then click Reset to Match Style. When you do this, the line style width and other data series settings will be reset to the chart style default settings.

Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12

Keywords: kbtshoot kbchart kbprb kbexpertisebeginner KB923873

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.