Line graph questions

[kgkev]

I have a data showing 4 variables that i would like to plot on a single graph.

Time: X axis (in 5 second intervals)
Temperature: Y axis.

I would like to plot

Target
Min
Max
Peak




The first 3 data sets look like this.


[TABLE="width: 239"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]TYPE[/TD]
[TD]TimeString[/TD]
[TD]VarValue[/TD]
[/TR]
[TR]
[TD]MAX_[/TD]
[TD="align: right"]11:52:58[/TD]
[TD="align: right"]1365[/TD]
[/TR]
[TR]
[TD]MIN_[/TD]
[TD="align: right"]11:52:58[/TD]
[TD="align: right"]1185[/TD]
[/TR]
[TR]
[TD]PEAK[/TD]
[TD="align: right"]11:52:58[/TD]
[TD="align: right"]1314[/TD]
[/TR]
[TR]
[TD]TARG[/TD]
[TD="align: right"]11:52:58[/TD]
[TD="align: right"]1250[/TD]
[/TR]
[TR]
[TD]MAX_[/TD]
[TD="align: right"]11:53:03[/TD]
[TD="align: right"]1365[/TD]
[/TR]
[TR]
[TD]MIN_[/TD]
[TD="align: right"]11:53:03[/TD]
[TD="align: right"]1185[/TD]
[/TR]
[TR]
[TD]PEAK[/TD]
[TD="align: right"]11:53:03[/TD]
[TD="align: right"]1314[/TD]
[/TR]
[TR]
[TD]TARG[/TD]
[TD="align: right"]11:53:03[/TD]
[TD="align: right"]1250[/TD]
[/TR]
[TR]
[TD]MAX_[/TD]
[TD="align: right"]11:53:08[/TD]
[TD="align: right"]1365[/TD]
[/TR]
[TR]
[TD]MIN_[/TD]
[TD="align: right"]11:53:08[/TD]
[TD="align: right"]1185[/TD]
[/TR]
[TR]
[TD]PEAK[/TD]
[TD="align: right"]11:53:08[/TD]
[TD="align: right"]1314[/TD]
[/TR]
[TR]
[TD]TARG[/TD]
[TD="align: right"]11:53:08[/TD]
[TD="align: right"]1250[/TD]
[/TR]
</tbody>[/TABLE]

is this possible in excel?
Maybe i need to reorganize my data?

 

[Oscar Cronquist]

I sorted the table based on TYPE and added MAX_, MIN_, PEAK and TARG to a series each.

 

[kgkev]

Excellent, works perfectly.
Thank you oscar

 

[VBA Geek]

You can rearrange the data like below using a pivot table and then create a sort of bullet graph: