Change series in a chart

  • Thread starter Thread starter trispirit32
  • Start date Start date
T

trispirit32

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
 
Back
Top