MS Graph: Plotting Series in Rows or Columns

 Last reviewed: September 10, 1996
Article ID: Q62987
The information in this article applies to:
  • Microsoft Graph version 1.0

SUMMARY

In charting, a series is one row or column of data used to draw one or more graphic elements on the chart; for example, one bar, line, or pie slice. What you type into the first row and column of cells and which orientation you choose (series in rows or series in columns) affect how the data is plotted on the chart. The default Graph chart is plotted with series in rows. 

          1st Qtr  2nd Qtr  3rd Qtr  4th Qtr
   East      20.4     27.4     90.4     20.4
   West      30.6     38.6     34.6     31.6
   North     45.9     46.9     45       43.9
In the example above, if you chose Series In Columns from the Datasheet menu, Graph would have plotted East, West, and North as the X axis, rather than the quarters.

MORE INFORMATION

To plot series in rows, follow these steps:

  1. Type series names in the first column and labels in the first row of the datasheet.

  2. Choose Series in Rows from the Datasheet menu if it isn't already selected. A checkmark appears next to the current selection in the menu.

The text down the first column of the datasheet will appear on the legend as series names. The text in the first row will appear on the horizontal axis of the chart as tick mark labels.

To plot series in columns, follow these steps:

  1. Type the labels in the first column and the series names in the first row.

  2. Choose Series In Columns from the Datasheet menu if it isn't already selected. A checkmark appears next to the current selection in the menu.

The text across the first row of the datasheet will appear on the legend as series names. The text in the first column will appear on the horizontal axis of the chart as tick mark labels.

For more information about this topic, refer to Pages 266-267, 279-282, and 386-387 of your "Microsoft PowerPoint for Windows User's Guide."

KBCategory: kbtool
KBSubcategory:

Additional reference words: 1.00 ms graph msgraph ms_graph



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: September 10, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.