Re: Dynamic Charting - User Selected Data Lines



Adapt the ideas at
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/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 <mikluk.1zbvum_1133385002.7109@xxxxxxxxxxxxxxxxxxxxx>,
mikluk.1zbvum_1133385002.7109@xxxxxxxxxxxxxxxxxxxxx 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?action=getinfo&userid=29236
> View this thread: http://www.excelforum.com/showthread.php?threadid=489584
>
>
.



Relevant Pages

  • Re: Automatic swap of x - and y - axis
    ... of the chart, and a description of the problem, someone may be able to help. ... Jon Peltier, Microsoft Excel MVP ... by the time the graph is ... Are the values that were plotted on the horizontal axis now ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... "Jon Peltier" wrote: ... of the chart, and a description of the problem, someone may be able to ... Jon Peltier, Microsoft Excel MVP ... by the time the graph is ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... that would keep the chart in its intended configuration. ... Jon Peltier, Microsoft Excel MVP ... The graph changes not when data are entered, ... Are the values that were plotted on the horizontal axis now plotted ...
    (microsoft.public.excel.charting)
  • RE: Insert graph with macro
    ... I just want the graph in the document that I’m ... that could be used to create the chart from. ... manipulated after inserting the chart. ... Dim o_OLE As Word.OLEFormat ...
    (microsoft.public.word.vba.general)
  • Re: Update "buildin" excel in a powerpoint with macro
    ... It runs fine the first attempt but on the second attempt the graph ... should be able to repeatedly update the chart with new data. ... Jim Gordon MVP skrev: ... Switch back to Excel and quit Excel ...
    (microsoft.public.mac.office.powerpoint)