Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
gpotavin
 
Posts: n/a
Default XY scatter plot with multiple data pairs for each variable

I need to create an xy scatter plot for 24 items (A through X). Each letter
(A-X) has 3 pairs of xy data.

For example Item A has data pairs x1y1, x2y2 and x3y3

However, when I plot these I get x1y1, y1x2, x2y2, y2x3 and x3y3. In
addition I need each item (A-X to appear in the legend only one time not
multiple times)

Can anyone help me with this??
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph
 
Posts: n/a
Default XY scatter plot with multiple data pairs for each variable

"gpotavin" wrote in message
...
I need to create an xy scatter plot for 24 items (A through X). Each
letter
(A-X) has 3 pairs of xy data.

For example Item A has data pairs x1y1, x2y2 and x3y3

However, when I plot these I get x1y1, y1x2, x2y2, y2x3 and x3y3. In
addition I need each item (A-X to appear in the legend only one time not
multiple times)

Can anyone help me with this??


How have you laid out your data, and how have you created the chart?
If you put your x1 x2 x3 values in one column and your y1 y2 y3 alongside
them in another column, you should get the plot you want.
--
David Biddulph


  #3   Report Post  
Posted to microsoft.public.excel.charting
gpotavin
 
Posts: n/a
Default XY scatter plot with multiple data pairs for each variable

David,

Thanks, I knew there was probably a simple fix but I had tried just about
evrything I could think of short of reformatting all the data.

In order to get the results I wanted I had to put the Name Label above the Y
values and I had to add each series one at a time to the graph by selecting
the xy pairs and label then doing a past special as a new series.

After doing all this I have exactly what I need.

THANKS!!!!

"David Biddulph" wrote:

"gpotavin" wrote in message
...
I need to create an xy scatter plot for 24 items (A through X). Each
letter
(A-X) has 3 pairs of xy data.

For example Item A has data pairs x1y1, x2y2 and x3y3

However, when I plot these I get x1y1, y1x2, x2y2, y2x3 and x3y3. In
addition I need each item (A-X to appear in the legend only one time not
multiple times)

Can anyone help me with this??


How have you laid out your data, and how have you created the chart?
If you put your x1 x2 x3 values in one column and your y1 y2 y3 alongside
them in another column, you should get the plot you want.
--
David Biddulph



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
multiple scatter graphes how to plot 3 sets of data for x y on th. frances Charts and Charting in Excel 3 May 2nd 23 11:42 AM
how to add data points to a scatter plot with trend line Samantha Charts and Charting in Excel 3 April 3rd 23 04:16 PM
A scatter plot with a 2 column data source SamB Charts and Charting in Excel 4 August 23rd 07 11:44 PM
Inserting a new line when external data changes Rental Man Excel Discussion (Misc queries) 0 January 11th 06 07:05 PM
Macro that will add data from multiple workbooks to the 1st open r jbsand1001 Excel Discussion (Misc queries) 0 April 23rd 05 07:52 PM


All times are GMT +1. The time now is 05:29 PM.

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

About Us

"It's about Microsoft Excel"