This article was previously published under Q214318
This article has been archived. It is offered "as is" and will no longer be updated.
When you save a custom chart type and apply it to a new chart, the dataseries and the x-axis labels revert to the defaults in Microsoft Excel.
Saving a custom chart type does not store whether the data series isoriented on the chart in rows or columns, or whether the x-axis labels arein the first row or first column. Therefore, if you apply the custom charttype to new data, the x-axis labels and orientation of the data series usethe defaults in Excel.
To adjust the orientation of the series after creating a custom chart:
Select the custom chart.
Click the Chart Wizard button on the Standard toolbar.
In step 1 of the Chart Wizard, click Next.
Under Series in, click the appropriate option, and then click the Series tab.
Specify the series and x-axis label information that you want and then click Finish.
Excel only stores the layout, existence of chart components, andformatting information of user-defined chart types, for example:
A secondary axis
Placement choices for various chart items
Excel does not store the exact data used to create the chart. Ifit did, you could only use autoformat on data sets of the same size.