Article ID: 192641 - View products that this article applies to.
This article was previously published under Q192641
If you create a combination chart of the Column-Area, Line-Column, or Line-Column on 2-Axes chart types, you may want to change the number of series plotted on each chart type. The Chart Wizard automatically takes half of the series (or one more than half, if there is an odd number of series) and makes it one chart type on the primary axis. It then puts the rest of the series as the other chart type on the secondary axis. If you want to change a particular series to the other chart type, or if you want to change the number of series in a particular chart type, you must edit the chart after you create it.
Because columns should appear side by side and areas typically appear stacked, all series that belong together must be on the same axis to appear as expected.
For example, Microsoft Excel places a column series plotted on the secondary axis in front of a column series plotted against the primary axis. In many cases, the overlay series obscures or overlaps the primary series.
Therefore, if you want to change a series from one chart type to the other in a combination chart, you must change both the chart type and the axis used.
Moving a SeriesThe following procedure describes the general steps you would use to move a series from a column to an area, an area to a column, or a line to a column in a combination chart.
NOTE: You must complete both step 2 and 3 to get the columns to display properly as a group and the areas to stack as a group, but you can complete these steps in either order.
NOTE: Not all chart types should be combined. In Excel 97, if you select a chart type that does not logically compare data in combination with existing chart types, you may receive the following error message:
However, it is possible at times to manually create illogical combinations of chart types (such as bars and columns, or pie and columns) without getting such a warning message.
Some chart types cannot be combined with other chart types. Select a different chart type.
The following example illustrates the steps you would use to change a series from a column series to an area series in a column-area chart.
Microsoft Excel 97
Microsoft Excel 5.0 and 7.0
For more information about changing the axis of a data series, click Contents And Index on the Help menu, click the Index tab in Excel 97 Help, type the following text
charts, data seriesand then double-click the selected text to go to the "plot a data series along a secondary axis in a 2-D chart" topic. If you are unable to find the information you need, ask the Office Assistant.
For more information about changing the chart type of a data series, click Contents And Index on the Help menu, click the Index tab in Excel 97 Help, type the following text
chart types, changingand then double-click the selected text to go to the "Select a different chart type" topic. If you are unable to find the information you need, ask the Office Assistant.
Article ID: 192641 - Last Review: August 18, 2005 - Revision: 1.3
Contact us for more help
Connect with Answer Desk for expert help.