Yes thats what im trying to do rather than reselecting the wanted colums to be drawn all the time i would like them to be drawn all at once in 4 separate XY Charts. For instance
1st drawing would be:
D vs G
2nd:
D vs I
3rd:
D vs K
4th:
D vs M
see pictures:
http://aycu18.webshots.com/image/377...2009991_rs.jpg
Rather than doing them manually i want them to be plotted once i select the X - axis in my case column D then all four are drawn with the same range of "D".
see my excel file please.
Bookmarks