Adapt the ideas at
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

particularly, example 4.

You can also use examples 5 and 6 to make the interface more user
friendly.

--
Regards,

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

In article ,
says...

I am looking for some ideas around creating a series of user friendly
charts where for ony one specific metric the user can select from up to
10 business units, which ones to compare on a single chart.

A chart with all 10 lines would be too busy but if a user wanted to
look at his/her BU and maybe 2 or 3 others which are close in size then
the chart would be useful.

I am imagining a box where the user can choose a few BU's and graph
just those. If the user wanted to change his/her selection they could
by unclicking/clicking on the choices and a new graph would be
generated.

Any thoughts?


--
mikluk
------------------------------------------------------------------------
mikluk's Profile: http://www.excelforum.com/member.php...o&userid=29236
View this thread: http://www.excelforum.com/showthread...hreadid=489584