ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   HELP with Graphing. (https://www.excelbanter.com/charts-charting-excel/114202-help-graphing.html)

scott

HELP with Graphing.
 
For my particular data sets the x axis represents displacement, and the y
axis represents load. I have multiple data sets; each has its own x and y
values. The chart wizard only lets me pick one of the series x values for
the entire graph. Is there a way i can graph all the data sets on the same
plot so that each data set is referenced to its own x values, as opposed to
just one of them.

Bernard Liengme

HELP with Graphing.
 
Plot the first data set
Select the second one (both x and y values) and copy
Click on Chart
Use menu item Edit | Paste Special and indicate New Series with x-values in
left column (with or without labels in first cell)
That the second data set added
Repeat to add more
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Scott" wrote in message
...
For my particular data sets the x axis represents displacement, and the y
axis represents load. I have multiple data sets; each has its own x and y
values. The chart wizard only lets me pick one of the series x values for
the entire graph. Is there a way i can graph all the data sets on the
same
plot so that each data set is referenced to its own x values, as opposed
to
just one of them.





All times are GMT +1. The time now is 09:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com