The information in this article applies to:
SUMMARYIf 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. MORE INFORMATION
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.
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 98, 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. 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:
REFERENCES
For more information about changing the axis of a data series, click the
Office Assistant, type How to change the axis of a chart series click
Search, and then click to view "Change the way data is plotted." Then,
click to view "Plot a data series along a secondary value axis."
Q179216 OFF98: How to Use the Microsoft Office Installer ProgramFor more information about changing the chart type of a data series, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in MS Excel Help, type the following text chart types, changingand then click Show Topics. Select the "Select a different chart type" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant. Additional query words: XL98
Keywords : kbdta kbchart |
Last Reviewed: January 13, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |