Chart with retail hour coverage

Bonkadonk

New Member
Joined
Jun 20, 2019
Messages
1
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
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,109,276
Messages
5,527,732
Members
409,786
Latest member
AbdulMoix

This Week's Hot Topics

Top