comparision please help

[mshailaja]

i have one excel sheet  (with in one week the order has to be delivered which are planned as scheduledorderstartdate and scheduled orderend date, but the order the staff is delivering like actual orderstartdate and actual orderenddate Now, the management  wants to check , at what time the staff is really working (means delivering the orders with in that  one week)

i want to represent the data in graph

and also need to create master calender for this (so that for every week user can check )

Please help

the format is like below

[mshailaja]

i need to present in guage chart with master calender , can you please help

[Anonymous]

Hi mshailaja,

See this post about canonical dates: Canonical Date

Regards!

[Anonymous]

Please, attach a file with your data and expected output.

Regards!