Change series in a chart

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top