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.
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.
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.
To adjust the orientation of the series after creating a custom chart:
Excel only stores the layout, existence of chart components, and formatting information of user-defined chart types, for example: