XL98: Series Data Orientation Not Saved in Custom Chart Type
Article ID: 191987
Article Last Modified on 9/11/2002
APPLIES TO
- Microsoft Excel 98 for Macintosh
This article was previously published under Q191987
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 Microsoft Excel.
This behavior is by design in the versions of Microsoft Excel listed at the
beginning of this article
WORKAROUND
To adjust the orientation of the series after creating a custom chart,
follow these steps:
- Select the custom chart, and click the Chart Wizard button on the
Standard toolbar.
- In step 1 of the Chart Wizard, click Next.
- Click the appropriate option under Series In, and then click the
Series tab to specify series and x-axis label information.
- Click Finish.
Additional query words: XL98
Keywords: kbchart kbprb KB191987