A B C D E F
1 Ray 1 3 5 7 9 11
2 Maureen 2 4 6 8 10 12
3 Sharon 3 5 7 9 11 13
4 Tim 4 6 8 10 12 14
5 Katie 5 7 9 11 13 15
6 Carl 6 8 10 12 14 16
The above table shows a set of made up data. I would like to be able to
automate the data I select to chart. Each time i do make a chart it should
plot the top row as the x axis and then the relevant data for the particular
person. ie 3,5,7,9,11,13 for Sharon. Can anyone suggest how this may be done
by perhaps using a combo box or some other means . Thank you