asked on

Dynamic graph in Excel

I tried to mimic a solution from dmille for a 2nd dynamic graph but I guess I just don't understand the basics of the offset function or even the dynamic graph.

I'd like to make attached 2nd bar graph a dynamic graph. Whereas the 1st graph shows month + ytd for ALL 5 questions, this bar graph would be for 1 question (and then I'd do the other 4) for the month selected via the same dropdown box.

Help?
Graph-jag4-v2.xls

ASKER CERTIFIED SOLUTION

dlmille

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jag4

ASKER

This is great - are you a professor?

I only have one question - is it possible to use the drop-down list to designate the months you want graphed? I've tried to insert the "O2" cell in the formula but it doesn't seem to change the manner in which the graph moves/chooses its month.
Copy-of-Graph-jag4-v2-1-.xls

dlmille

Do you want a from and a to month? Or to select one to many from a list of months?

dlmille

The graph you originally created was for 1 dimension - Satisfaction. Do you mean to only plot one month on that dimension, or a from / to months? Do you mean to plot the same graph as above, but exclude the YTD? Or do you mean to plot ALL dimensions but for one month or a series of months?

Please provide more information

jag4

ASKER

This works, Dave. No need to make it any fancier. Thanks for the lesson, - I plan to sit down now and learn how to do this!!! tHanks for the link, as well.