make a interactive chart by month of daily deliviry

[Jurgen Smits]

Hello,

I hope some one can help me.

I want make an chart by month of daily delivery. When I want chose a the month (by validation list), when I want do it by the offset fonction, I get stuck because the number of days is every month different.

Kind regards

Jürgen Smits

 

[Hui]

Have a loo at this implementation
It uses Named Formula to first calculate the Starting offset of the Selected Month, the the No of Days in the Month
It then sets up a Named Formula XData that has the Dates and then offsets that 1 column for the YData

Then use the Named Formulas in the chart

 

[Jurgen Smits]

Thanks

It works 100%

Thank you very much

Jürgen Smits