The zipped file worked fine and I would be able to use this but in excel 2002
I do n ot seem to get the control ion the combo box to enter the linked cell
and range. I have tried to do this through "properties" and have added in the
linked cell and range but to no effect. Can anyone explain how in excel 2002
when you have select a combo box you can get a list to show so that when you
select the required value the linked cell is updates. Thank you

"Raymond Willis" wrote:

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