Hi folks, very new to Excel and need to do a chart that im not too sure how to do, although im sure its possible with how exceptional of a program this is.
Basically, I need to do a chart (bars probably easiest), that would have Sunday to Saturday along the top and opening hours along the Y axis - this then to be editable with hours that there is coverage.
I.e. 8am-9pm Opening Hours, coverage for this day would be 9am-6pm, however this is a wide scale spreadsheet, so this value will differ and will need to be editable.
Can this be done and can anyone guide me through it? I have attached a photo of the idea I mean, this may or may not help.
Thanks,
Luke
Basically, I need to do a chart (bars probably easiest), that would have Sunday to Saturday along the top and opening hours along the Y axis - this then to be editable with hours that there is coverage.
I.e. 8am-9pm Opening Hours, coverage for this day would be 9am-6pm, however this is a wide scale spreadsheet, so this value will differ and will need to be editable.
Can this be done and can anyone guide me through it? I have attached a photo of the idea I mean, this may or may not help.
Thanks,
Luke