Hi,

I am trying to create scattered chart in excel 2010 with Days of the week (viz: Mon, Tue, Wed, Thu, Fri) on X-axis and Time (starting from 09:15, 09:30, 10:00, 10:30, 11:00, 11:30, 12:00 i.e. every half hour interval except the first two). Plotting will be done based on the day of the week and time of that day. However, there is third data as well which is to be plotted as area based on the time (i.e. say Mon from 09:30 to 11:00 which could be varying for different days of the week).

Any help would be appreciated. Many thanks in advance for your kind help.
Regards,