XL2000: Series Data Orientation Not Saved in Custom Chart Type

Article translations Article translations
Article ID: 214318 - View products that this article applies to.
This article was previously published under Q214318
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

SYMPTOMS

When you save a custom chart type and apply it to a new chart, the data series and the x-axis labels revert to the defaults in Microsoft Excel.

CAUSE

Saving a custom chart type does not store whether the data series is oriented on the chart in rows or columns, or whether the x-axis labels are in the first row or first column. Therefore, if you apply the custom chart type to new data, the x-axis labels and orientation of the data series use the defaults in Excel.

WORKAROUND

To adjust the orientation of the series after creating a custom chart:
  1. Select the custom chart.
  2. Click the Chart Wizard button on the Standard toolbar.
  3. In step 1 of the Chart Wizard, click Next.
  4. Under Series in, click the appropriate option, and then click the Series tab.
  5. Specify the series and x-axis label information that you want and then click Finish.

MORE INFORMATION

Excel only stores the layout, existence of chart components, and formatting information of user-defined chart types, for example:
  • Legend

  • Gridlines

  • Data labels

  • A secondary axis

  • Colors

  • Patterns

  • Fills

  • Placement choices for various chart items

  • Fonts
Excel does not store the exact data used to create the chart. If it did, you could only use autoformat on data sets of the same size.

Properties

Article ID: 214318 - Last Review: October 14, 2013 - Revision: 3.0
APPLIES TO
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbchart kbprb KB214318

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com