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


--
trispirit32
------------------------------------------------------------------------
trispirit32's Profile: http://www.excelforum.com/member.php...o&userid=25580
View this thread: http://www.excelforum.com/showthread...hreadid=390050

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 ,
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