#1   Report Post  
frances
 
Posts: n/a
Default 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?

  #2   Report Post  
Alex
 
Posts: n/a
Default

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?

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



All times are GMT +1. The time now is 04:01 AM.

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"