The information in this article applies to:
- Microsoft Excel for Windows, versions 3.0, 4.0, 5.0
- Microsoft Excel for OS/2, version 3.0
- Microsoft Excel for the Macintosh, version 3.0, 4.0
SUMMARY
When using Microsoft Excel, you can create an XY (scatter) chart with
multiple, noncontiguous ranges of Y values.
MORE INFORMATION
Version 5.0
- Enter the following into a worksheet
A1: B1: y C1: D1: y E1: F1: y
A2: 2 B2: 3 C2: D2: 1 E2: F2: 5
A3: 4 B3: 5 C3: D3: 3 E3: F3: 6
A4: 5 B4: 6 C4: D4: 7 E4: F4: 9
- Select cells A1:B4. Please note that the Y labels in Row 1 cannot
be left out and that cell A1 is left blank.
- Holding down CTRL, select cells D1:D4 and F1:F4.
- From the Edit menu, choose Copy.
- Select cell A1 (or any blank cell).
- From the Insert menu, choose Chart, then select As New Sheet.
- From the Edit menu, choose Paste Special. Select Values Y in
Columns, Categories (X Labels) in First Column, and choose OK.
- In the Format menu, select Chart Type, then select XY (Scatter),
and choose OK.
Version 3.0, 4.0
- Enter the following into a worksheet
A1: B1: y C1: D1: y E1: F1: y
A2: 2 B2: 3 C2: D2: 1 E2: F2: 5
A3: 4 B3: 5 C3: D3: 3 E3: F3: 6
A4: 5 B4: 6 C4: D4: 7 E4: F4: 9
- Select cells A1:B4. Please note that the Y labels in Row 1 cannot
be left out and that cell A1 is left blank.
- Holding down CTRL, select cells D1:D4 and F1:F4.
- From the Edit menu, choose Copy.
- Select cell A1 (or any blank cell).
- From the File menu, choose New and select Chart.
- From the Edit menu, choose Paste Special. Select Values Y in
Columns, Categories (X Labels) in First Column, and choose OK.
- In the Gallery menu, select the desired XY chart form.
This allows all three Y plots to correspond with the X coordinates.
|