Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
how to add data points to a scatter plot with trend line | Charts and Charting in Excel | |||
A scatter plot with a 2 column data source | Charts and Charting in Excel | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) |