Dynamic combination chart -daily updation

[amit_gupta123]

Hiii..trying to figure out a chart having two value axis and dates of month on X axis. The value on y1 & y2 axis are the time/hours.

i am looking that dates are fixed on X axis and chart gets updated dynamically on daily basis

Please help
Regards

 

[Hui]

Amit

A few things

I have added 3 Named Formula for the Date and Two time Series
The Chart is linked to the Named Formula not the Ranges

The Times should be entered with a space between the time and the AM/PM
Wrong 4:32PM
Right 4:32 PM

The first is received as a text string not a date

I have manually deleted the values where Sunday is so that Gaps appear

see below and attached: