Hi trispirit32,

One way is shown in 'Chart Selector' at
http://edferrero.m6.net/charting.aspx

Ed Ferrero
http://edferrero.m6.net

>
> 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
>
>
> --
> trispirit32
> ------------------------------------------------------------------------
> trispirit32's Profile:
> http://www.excelforum.com/member.php...o&userid=25580
> View this thread: http://www.excelforum.com/showthread...hreadid=390050
>