Graph from multiple data series

[oriwitt]

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

 

[Jon Peltier]

I'm sorry, but I can't comprehend how the sets of data you have correspond to any charted series. Could you show a screenshot of the data and chart, and describe again how you want the new chart to look?