Creating Chart with More Series than Categories (Fast Method)

Last reviewed: November 3, 1994
Article ID: Q73553
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
  • Microsoft Excel for OS/2, versions 2.2, 2.21, and 3.0

SUMMARY

The way that Microsoft Excel plots data in a chart is determined by the shape and content of the worksheet selection. Microsoft Excel always assumes that you want fewer data series than categories (except with scatter charts). You can override this default in Microsoft Excel version 5.0 by using the ChartWizard to create the chart. In Microsoft Excel versions 2.0, 3.0 and 4.0, you can override this default by selecting the worksheet data as a multiple selection.

More Information

To create a chart that has more data series than categories, consider the following example:

Example

  1. Enter the following data on a worksheet:

          A1:             B1: Col1        C1: Col2
          A2: Row1        B2:  10         C2: 12
          A3: Row2        B3:  13         C3: 15
          A4: Row3        B4:  11         C4: 13
    
    

  2. Select cells A1:C4 and press F11 to create a new chart. Because there are more rows in the worksheet data than columns, "Row1"-"Row3" are placed as the labels on the X-axis (category axis). Close the chart.

Microsoft Excel version 5.0

a. Select cells A1:C4. From the Insert menu, choose Chart, and then choose

   As New Sheet.

b. In the ChartWizard - Step 1 of 5 dialog box, choose Next. Choose Next
   two more times.

c. In the ChartWizard - Step 4 of 5 dialog box, under Data Series In,
   select the Rows option. In the Use First Row(s) For Category (X) Axis
   Labels box, type "1" (without the quotation marks). Choose Finish.

Microsoft Excel versions 2.0, 3.0 and 4.0

a. Select the data on the worksheet again, this time as a multiple

   selection. First, select cells B1:C1 (the desired category names).
   Hold down the CTRL key and select cells A2:C4. To make this selection
   using the keyboard, select cells B1:C1, press SHIFT+F8 and then select
   cells A2:C4.

b. Press F11 to create a new chart.

Note that this time "Col1" and "Col2" are placed as labels on the X-axis.

To accomplish this method with other data, select the desired category names first, and then select the remaining data as a second or multiple selection before creating the chart.

REFERENCES

"Microsoft Excel User's Guide." Version 3.0, pages 406-407.


KBCategory: kbusage
KBSubcategory:

Additional reference words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00
3.0 4.00 5.00


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.