ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Please help!!!! (https://www.excelbanter.com/excel-discussion-misc-queries/770-please-help.html)

frances

Please help!!!!
 

I would like to know how to plot multiple sets of data on a scatter graph for
example i have 3 sets of data for three types of lighting systems, red, green
and blue i want to plot the voltage againt the current, and i want all the
data on one graph so i can compare them, how do i do it?


Alex

Frances

I suggest you try the following.

Plot a scatter graph as normal with your first set of data.

Then to add more data to the scatter graph...

Right click on chart and select <Source Data and select the <Series tab.

Select <Add in the series dialog box and type in the relevant sections
opposite the cell references of your new x and y values. Your second set of
data will now appear on the chart. Just repeat to add a third series.

I hope this helps. Please feel free to write back if you are still having
difficulties and I shall endeavour to assist further.

Regards


Alex

"frances" wrote:


I would like to know how to plot multiple sets of data on a scatter graph for
example i have 3 sets of data for three types of lighting systems, red, green
and blue i want to plot the voltage againt the current, and i want all the
data on one graph so i can compare them, how do i do it?



All times are GMT +1. The time now is 01:38 PM.

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