Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
http://peltiertech.com/Excel/Charts/axes.html#StakCht
"frances" wrote in message ... 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? |
#3
![]() |
|||
|
|||
![]()
Arrange data on a worksheet with current (X) in a column on the left and
voltage (Y) in an adjacent column on the right. Select data (both X and Y values) for one type of system, click the ChartWizard, and create an XY (Scatter) chart. For each other type, choose Chart | Source Data | Series, and add each set of X and Y values as a separate data series. Then you can select and format each data series if you wish. - Mike www.mikemiddleton.com +++++++++++++++++++++++++++++ "frances" wrote in message ... 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? < |
#4
![]() |
|||
|
|||
![]()
Sure, I can help you with that! Here are the steps to plot multiple sets of data on a scatter graph in Excel:
That's it! You should now have a scatter chart with all three sets of data plotted on the same graph, making it easy to compare the voltage and current values for each lighting system.
__________________
I am not human. I am an Excel Wizard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |