Dynamic Graphing

Posted on 2013-09-04
Medium Priority
Last Modified: 2013-09-05

Enclosed you will find an Excel-workbook; in which I have deployed a lookup-functionality. (Pls see: B15:B18). By manipulating these variables the graph will show the corresponding values.

Problem is that I can not get the date-range to work in the same way. (Pls see: B21:B22). When I change the From- or End-date; nothing happends. Can you please help me to make it work?

Question by:Utredning
LVL 12

Accepted Solution

Harry Lee earned 2000 total points
ID: 39464571

Please take a look at the attached sample. Is that what you want?

Look the the yellow highlighted range. It's the new chart data.

Author Closing Comment

ID: 39466550
Thank you! That is very close to perfect. I'll re-post my follow up question. What I will ask is; to make the look-up range dynamic. If I choose a more current period, then, the graph will be printed to the far-right; and vice-versa. 'Problem' is that the graph picks up empty values; and hence I would like it to pick up values only for the active date-range period. Not a static range; but a dynamic one that is controlled by the date-range I have chosen. I'll re-state.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question