Scatter Graph where Data Series is Listed in Each Row

SamBlackmore

New Member
Joined
Nov 18, 2014
Messages
1
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:

TimeSeriesValue
1London88
2Manchester57
3Manchester42
4Liverpool11
5London93
6Liverpool39

<tbody>
</tbody>


Many thanks for your help.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,213,532
Messages
6,114,177
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top