Conditional Chart Range

[starbuk]

Hi! I am trying to have a chart which has a conditional range. The data looks like this (my attach function is not working, here is a link):

A B
Date Value1
1/1/2017 2
2/1/2017 1
3/1/2017 6
4/1/2017 4
5/1/2017 5
6/1/2017 8
7/1/2017 9
8/1/2017 4
9/1/2017 5
10/1/2017 6
11/1/2017 7
12/1/2017 <--- this will fill in once the date passes
1/1/2018 <--- this will fill in once the date passes

There is a chart which is made up of the range in columns A and B. What I'd like to happen is once a new value comes in, the chart range updates automatically. I think the solution has to do with a formula in the Names Manager which includes offset, count, index but it's too confusing for me to put together or understand. If I can gets this done I will be able to automate many tasks using Windows Task Manager.

Thank you all for looking and trying to help me with my project.

[starbuk]

I've added an attachment to this post.

[Olly]

Create the following defined names:

chtLabels:

Please Login or Register  to view this content.

chtValues:

Please Login or Register  to view this content.

Insert a chart, choose Select Data Source, and change the following:

Series values:

Please Login or Register  to view this content.

Axis labels:

Please Login or Register  to view this content.

See attached file for a worked example.

[starbuk]

This is so clear and helpful - thank you very very much!

[Olly]

Happy to help, thanks for the feedback.