Scatter Graph where Data Series is Listed in Each Row

[SamBlackmore]

Hello,

Sorry if this has been covered elsewhere, I couldn't find an answer from searching. I'm trying to create a scatter graph where the data series were recorded in each row rather than as separate columns. I have hundreds of values that fall into many different series and I would like to see each represented as lines on a scatter graph against time. I have tried using filters to get the values for each series and then manually copy and paste them into separate columns but this is tedious and seems inefficient. Below is a fictional example with only 3 series:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Time[/TD]
[TD]Series[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]London[/TD]
[TD]88[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Manchester[/TD]
[TD]57[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Manchester[/TD]
[TD]42[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Liverpool[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]London[/TD]
[TD]93[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Liverpool[/TD]
[TD]39[/TD]
[/TR]
</tbody>[/TABLE]


Many thanks for your help.

 

[Jon Peltier]

This tutorial describes shows how to do what you want: Split Data Range into Multiple Chart Series without VBA.