I have a range of data which I would like to plot on to an existing graph using script. But because of the type of data I’m plotting, it’s a little complicated.

For every name and y value, I have 3 x values. I have 64 of these.

Therefore for each row, it looks something like this:

Y Value, Name, Xvalue 1, X Value 2, Xvalue 3

Y Value, Name, Xvalue 1, X Value 2, Xvalue 3

Y Value, Name, Xvalue 1, X Value 2, Xvalue 3

Y Value, Name, Xvalue 1, X Value 2, Xvalue 3

(and so on)

I would like the graph to plot three sets of data per row (taken from the 3 x values). And then i want it to go to the next row down and do the same thing until it reaches the end of the list.

I can do it manually but I’m struggling with the script.

By: Faye