Excel: Creating Scatter Charts with Multiple X Ranges

• Microsoft Excel for Windows, versions 2.1, 3.0, 4.0
• Microsoft Excel for the Macintosh, versions 1.5, 2.2, 3.0, 4.0
• Microsoft Excel for OS/2, versions 2.2 and 3.0

SUMMARY

The usual chart series for an XY Scatter Chart has a range of Y Values mapped to a range of X Categories. If there are more than two series, the chart has multiple Y ranges mapped to a single range of X values.

To create a Scatter chart with one range of Y values mapped to multiple ranges of X categories in Microsoft Excel version 3.0 or 4.0, follow these steps:

1. Make sure the single range of cells you use for Y Values is after the cells for your X Categories (to the right, if your values are in columns; below, if your values are in rows).



2. Select one X range and the Y range. Press COMMAND+Select (on the Macintosh) or press CTRL (on an IBM-compatible computer) if the areas are not contiguous.



3. From the File menu, choose New and select the Chart option.



4. Select the second X range and the same Y range. From the Edit menu, choose Copy.



5. Click the the chart window to activate it. From the Edit menu, choose Paste Special.



6. Select Values (Y) in Columns and Categories (X values) in First Column options and click OK.



7. Repeat steps 4 and 5 for each additional series.

1. Create new columns or rows next to each column of X values.



2. Copy and Paste the same Y values into the blank columns to the left of each column of X values.



3. Follow steps 2 through 7 above, but do not try to select values as discontinuous ranges.

Additional query words: 1.5 2.1 2.20 3.0

Keywords :
Version :
Platform :
Issue type :