dynamically update chart based on cell value

[Bax]

Hi Experts,

Again need your wisdom

Attached file has a simple chart (3 series).
User can choose the month (cell C2), and the chart will then need to show the data per day of that choosen month as listed in the data table (column L:O).
I can find various solutions with dynamic name ranges, but all of these won't show me how to change the data range from e.g. L2:O8 when I choose October in cell C2 and have the range changed to L9:O29 when I choose November in cell C2, so that the chart will dynamically update the graphs for these 3 series.

Is there any way I can get this to work?

Thanks all for the time and effort!!
graph.xlsx

[Kaper]

Proposed names:

Please Login or Register  to view this content.

first_day and number_days are used in further formulas
Serie1...3 are real series data
and
dates are horizontal axis labels

[Pete_UK]

What you need to do is derive a second table from your main data which only shows the data for the chosen month, and use this as the source for your chart. The attached file shows how this can be done.

Hope this helps.

Pete

[Bax]

Perfect guys!

Interesting to see that Kaper uses defined names and Pete uses a helper table, both resulting in the desired output

I've learned a lot again, many thanks to both!!