• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

Dynamic Graphing with dynamic series

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.

What I would like to ask for your help on is to make the 'series look-up range' dynamic. Like, 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.

Thank you.
2 Solutions
Rob HensonFinance AnalystCommented:
You can use the OFFSET function as a formula within a Named Range "Refers to" parameter to make the named range dynamic.

You then refer to the named range in the graph series.

Rob H
UtredningAuthor Commented:
Hi - Rob H
Could you please make the nesseary amendments in the formulas to make it work and post the solution? (My formula-competence limited hence I ask for this favour). Thanks, Vetle
Hi Vetle, here is an update of your sheet, using same basis as Rob Henson
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now