Visual Maintenance Schedule in Excel for Management Reporting

I need to make a visual schedule in Excel that can be used to review upcoming task schedule and considers how long each task is expected to take. This will be used to report out what tasks need to be done this week, what was done last week, and how we are doing on the expected schedule (actual vs. budget). I am familiar with Excel, but I do not have time to create this. I would like the visual/Pivot Chart to be dynamic. Must be able to create something that looks good and is simple. Must be able to take instructions, respond to feedback and also provide suggestions on how more information could make the visuals better.