Hello,

I would like to have an interactive graph but cannot work out how to do this
despite studying old posts.

I have two sets of data, range A and range B. When the user goes to
'results' sheet, they will automatically see range A displayed on the graph.
If they select range B from a dropdown menu, I would like the graph to change
to reflect the change in data range. Is this possible with not much previous
knowledge of macros?

Many thanks for your help in advance.

--

Johanna

You can do this w/o any macros, just using a combo box (or check box) from
the forms toolbar.

Jon Peltier has quite a few articles about dynamic charting.
http://peltiertech.com/Excel/Charts/Dynamics.html

I think this one would be most relevant to you:
http://peltiertech.com/Excel/Charts/ChartByControl.html
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Johanna Gronlund" wrote:

> Hello,
>
> I would like to have an interactive graph but cannot work out how to do this
> despite studying old posts.
>
> I have two sets of data, range A and range B. When the user goes to
> 'results' sheet, they will automatically see range A displayed on the graph.
> If they select range B from a dropdown menu, I would like the graph to change
> to reflect the change in data range. Is this possible with not much previous
> knowledge of macros?
>
> Many thanks for your help in advance.
>
> --
>
> Johanna