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:
<tbody>
</tbody>
Many thanks for your help.
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:
Time | Series | Value |
1 | London | 88 |
2 | Manchester | 57 |
3 | Manchester | 42 |
4 | Liverpool | 11 |
5 | London | 93 |
6 | Liverpool | 39 |
<tbody>
</tbody>
Many thanks for your help.