View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Johanna Gronlund Johanna Gronlund is offline
external usenet poster
 
Posts: 32
Default Chart content to change according to a selection on a combobox

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