ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   HOw do I do this? (https://www.excelbanter.com/charts-charting-excel/110025-how-do-i-do.html)

Kim K

HOw do I do this?
 
I am trying to help my daughter and do a graph of the following data:

12 different times and 12 different temperatures, I am assuming that I
should do 2 seperate line graphs, but how do I overlay or combine the times
with teh temps?

Any ideas and or alterations to my thinking appreciated!
--
Thanks,,
Kim

[email protected]

HOw do I do this?
 
You probably want an "XY Scatter Chart"
On Step two of the wizard select the Series Tab at the top.
Then you can add data for the X axis and the Y axis.

Kim K wrote:
I am trying to help my daughter and do a graph of the following data:

12 different times and 12 different temperatures, I am assuming that I
should do 2 seperate line graphs, but how do I overlay or combine the times
with teh temps?

Any ideas and or alterations to my thinking appreciated!
--
Thanks,,
Kim



Kim K

HOw do I do this?
 
Will this correlate the times wiht teh right temps? UNless I am doing
something wrong I can not get it to do what I want. Lets say that a certain
experiment happens at 70 degrees in 4:19 and then a repeat happens at 64
degrees at 5:05. HOw do I show this progression? I can put all times on the
X axis and the temps on the Y, but to show them together is what I want.
HOpe this makes sense.
--
Thanks,,
Kim


" wrote:

You probably want an "XY Scatter Chart"
On Step two of the wizard select the Series Tab at the top.
Then you can add data for the X axis and the Y axis.

Kim K wrote:
I am trying to help my daughter and do a graph of the following data:

12 different times and 12 different temperatures, I am assuming that I
should do 2 seperate line graphs, but how do I overlay or combine the times
with teh temps?

Any ideas and or alterations to my thinking appreciated!
--
Thanks,,
Kim




Bernard Liengme

HOw do I do this?
 
Send (my private email) me the data and I'll make the graph.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kim K" wrote in message
...
Will this correlate the times wiht teh right temps? UNless I am doing
something wrong I can not get it to do what I want. Lets say that a
certain
experiment happens at 70 degrees in 4:19 and then a repeat happens at 64
degrees at 5:05. HOw do I show this progression? I can put all times on
the
X axis and the temps on the Y, but to show them together is what I want.
HOpe this makes sense.
--
Thanks,,
Kim


" wrote:

You probably want an "XY Scatter Chart"
On Step two of the wizard select the Series Tab at the top.
Then you can add data for the X axis and the Y axis.

Kim K wrote:
I am trying to help my daughter and do a graph of the following data:

12 different times and 12 different temperatures, I am assuming that I
should do 2 seperate line graphs, but how do I overlay or combine the
times
with teh temps?

Any ideas and or alterations to my thinking appreciated!
--
Thanks,,
Kim







All times are GMT +1. The time now is 12:46 PM.

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