oriwitt
Board Regular
- Joined
- Mar 26, 2016
- Messages
- 89
Hi,
I have multiple data series provided from a source in a format similar to
SeriesName1
NameTitle DataPoint1Title DataPoint2Title DataPoint3Title
Person1 DataPoint1 DataPoint2 DataPoint3
Person2 DataPoint1 DataPoint2 DataPoint3
etc
SeriesName2
NameTitle DataPoint1Title DataPoint2Title DataPoint3Title
Person1 DataPoint1 DataPoint2 DataPoint3
Person2 DataPoint1 DataPoint2 DataPoint3
etc
and so on
It's worth noting I think that names may appear in multiple series, however not in the same order.
What I'm looking to do is chart multiple series where for example Person1 DataPoint3 is graphed to show the trend of that data between series.
I've tinkered briefly with multiple series xy scatters and pivot tables/graphs but can't seem to get it how I mention. Any suggestions?
Kind regards,
Ori
I have multiple data series provided from a source in a format similar to
SeriesName1
NameTitle DataPoint1Title DataPoint2Title DataPoint3Title
Person1 DataPoint1 DataPoint2 DataPoint3
Person2 DataPoint1 DataPoint2 DataPoint3
etc
SeriesName2
NameTitle DataPoint1Title DataPoint2Title DataPoint3Title
Person1 DataPoint1 DataPoint2 DataPoint3
Person2 DataPoint1 DataPoint2 DataPoint3
etc
and so on
It's worth noting I think that names may appear in multiple series, however not in the same order.
What I'm looking to do is chart multiple series where for example Person1 DataPoint3 is graphed to show the trend of that data between series.
I've tinkered briefly with multiple series xy scatters and pivot tables/graphs but can't seem to get it how I mention. Any suggestions?
Kind regards,
Ori