Expand and Collapse Date Cells - Gantt Chart

[hrmason]

Hi guys, I am new to this so will try and explain my problem as simply as possible.

I am trying to basically show a visual representation of a calendar of events in the gantt chart form (attached example), so would love to be able to change the view so I can see by events by day, by week, by month and by quarter etc by expanding/collapsing the relevant cells. I have been able to work out how to expand all cells so that I can see the chart by day (although as you can imagine, this is a tad excessive considering it goes on for three years!). However I can't work out the following:

a) I don't know how to get it to revert to the overview you currently see.

b) I don't know how to expand for week, month and quarter (or if this is even possible) - and how to expand only a certain selection (e.g. January or Qtr 1).

Does anyone have any ideas? I have been searching a number of forums and posts and cannot find anything that helps! Please bear in mind that I am not an excel expert as well.

Thanks for any help!

Hannah