marlonsaveri
Board Regular
- Joined
- Jan 28, 2011
- Messages
- 68
Hello, my question is this:
Suppose I have multiple rows; in the first column, the name of the series; in the second, a value X and, it the third, a value Y.
example:
Name____X_______Y
John____10_______20
John____11_______25
Alex_____09______14
John____12_______21
Alex_____11_______19
etc
I would like to draw graphics of dispersion and then draw trend lines. So, it should have one line for each name (John, Alex,...); on the x axis, the values X and, on the y axis, the values Y.
However, I am not able to do that; excel is not associating one John with other, but creating new series.
I need to do this using VBA (because the tables is made by VBA). Maybe, if I discover how to do it "manually", I might be able to do in VBA.
To make matters worse; actually It doesn't have a single value of Y, but a Ymax and Ymin. Hence, I need to do this kind of graphic, but using as parameter the two values of Y.
Thanks very much
Suppose I have multiple rows; in the first column, the name of the series; in the second, a value X and, it the third, a value Y.
example:
Name____X_______Y
John____10_______20
John____11_______25
Alex_____09______14
John____12_______21
Alex_____11_______19
etc
I would like to draw graphics of dispersion and then draw trend lines. So, it should have one line for each name (John, Alex,...); on the x axis, the values X and, on the y axis, the values Y.
However, I am not able to do that; excel is not associating one John with other, but creating new series.
I need to do this using VBA (because the tables is made by VBA). Maybe, if I discover how to do it "manually", I might be able to do in VBA.
To make matters worse; actually It doesn't have a single value of Y, but a Ymax and Ymin. Hence, I need to do this kind of graphic, but using as parameter the two values of Y.
Thanks very much