Dynamic Charting - User Selected Data Lines

[mikluk]

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?

[Tushar Mehta]

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 <[email protected]>,
[email protected] 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
>
>