I'm trying to plot up to 7 lines on a scatter chart, but am having trouble
getting it to work. I'm a bit of a beginner with excel, and have worked out
basic scatter charts, but I now need one that presents multiple lines for
each 'item'. I'm not explaining this every well.. but does anyone know what I
mean? The chart I have to work from and duplicate is in JPEG form so I can't
just adjust the figures and re-plot.. it sort of looks like a rainbow with
all the different lines curving, one higher than the other...

Creating a Scatter Chart with Multiple Lines in Excel

1. Open your Excel spreadsheet and select the data you want to use for your chart. Make sure you have all the data you need for each line in separate columns.
2. Click on the "Insert" tab in the top menu bar and select "Scatter" from the "Charts" section.
3. Choose the type of scatter chart you want to use. For multiple lines, you'll want to select the option that includes lines.
4. Once you've selected your chart type, Excel will create a basic chart for you. Right-click on the chart and select "Select Data" from the drop-down menu.
5. In the "Select Data Source" window, click on the "Add" button to add a new data series.
6. In the "Edit Series" window, enter a name for your new data series and select the data range for the X and Y values. Repeat this step for each line you want to add to your chart.
7. Once you've added all your data series, you can customize your chart by adding titles, labels, and adjusting the formatting to your liking.
8. Finally, save your chart and you're done!

I hope this helps you create the chart you need. Let me know if you have any questions or if there's anything else I can help you with.

Put your X data in column A, starting in A2 and running down. Leave cell A1
empty.
Put your corresponding 1st Y series in column B, starting in B2 and running
down. Put the title of this series in B1
Put your 2nd Y series in column C, starting in C2 and running down. Put the
title of this series in C1
.... and so on to your 7th Y series in column H, starting in H2 and running
down. Put the title of this series in H1.

Select the full range of data, from A1 to Hn.
Insert menu/ Chart .../ follow the wizard (accepting data in columns),
choosing appropriate options as you go.
--
David Biddulph

"Amy" wrote in message
...
I'm trying to plot up to 7 lines on a scatter chart, but am having
trouble
getting it to work. I'm a bit of a beginner with excel, and have worked
out
basic scatter charts, but I now need one that presents multiple lines for
each 'item'. I'm not explaining this every well.. but does anyone know
what I
mean? The chart I have to work from and duplicate is in JPEG form so I
can't
just adjust the figures and re-plot.. it sort of looks like a rainbow with
all the different lines curving, one higher than the other...