Hi guys,

My first post. I have data for residents of the care home that I work at. One example is their monthly weights. I presently have the data in the following form:

jan feb mar apr may
Resident 1 108 109 107 105 106
Resident 2 220 225 219 226 222

I would like to have a control box or something on the line chart of a resident's weights so that I can choose which resident's monthly weights to display. The x-axis is the month and the y-axis the weight. I can't seem to figure out how to get a macro to do this.
Thanks a bunch
Stuart