Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Amy Amy is offline
external usenet poster
 
Posts: 165
Default How do I put multiple lines on a scatter chart?

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...

  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How do I put multiple lines on a scatter chart?

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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default How do I put multiple lines on a scatter chart?

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...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scatter Chart w/ Lines limit? Maurolava Charts and Charting in Excel 3 January 29th 09 09:23 PM
Using drop lines with XY scatter chart SMACS03 Charts and Charting in Excel 1 February 8th 06 03:47 AM
Scatter Chart with Smoothed Lines rachsull Charts and Charting in Excel 4 January 31st 06 06:18 PM
difference between 2 lines in a scatter chart prd02003 Charts and Charting in Excel 5 August 2nd 05 04:31 PM
Limit lines in XY scatter chart Cygnusx1 Charts and Charting in Excel 1 April 26th 05 08:48 PM


All times are GMT +1. The time now is 09:53 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"