Change series in a chart

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

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
>

No need for a macro. Adapt the ideas at
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html
specifically example 4.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
>
> 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
>
>