XL98: Adding Series to XY (Scatter) Chart with Second X Axis
ID: Q192288
|
The information in this article applies to:
-
Microsoft Excel 98 Macintosh Edition
SUMMARY
When you add a second series to an xy scatter chart, the new values will
be added with respect to the same x-axis values as the first series. This
article illustrates how to add a second series to an xy scatter chart that
utilizes a second set of x values.
MORE INFORMATION
The following steps illustrate how to add a second series to an xy scatter
chart using a different set of x values.
- Enter the following data into a worksheet:
A1: 1 B1: 5 C1: -1 D1: -5
A2: 2 B2: 6 C2: -2 D2: -6
A3: 3 B3: 4 C3: -3 D3: -8
A4: 4 B4: 2 C4: -4 D4: -5
A5: 5 B5: 5 C5: -5 D5: -1
- Select the range A1:B5. On the Standard toolbar, click the Chart Wizard
tool.
- In the list of chart types, click XY (Scatter). Click one of the line
charts under Chart Sub-type. Click Next.
- Click the Series tab. Then, click Add. In the X Values box, type
C1:C5; in the Y Values box, type D1:D5. Then, click Finish.
- In the chart, double-click the second series to display the Format Data
Series dialog box. Click the Axis tab. Click Secondary Axis and click
OK.
Additional query words:
XL98
Keywords : kbdta kbchart
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbhowto