Is this the sort of thing you had in mind?

http://www.andypope.info/ngs/ng47.htm

Cheers
Andy

Meltad wrote:
Hi,

I was wondering if anybody knew what would be the best/most impressive way
to present some information...

I need to display all company activity (e.g periods of particular peak
activity in various departments) against a sort of timeline for the year.
There could be several/overlapping periods of peak activity for any one
department at any one time...

I thought a bubble chart but I want the year timespan and the distinct
departmental reponsibilities for the action to be clear...


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info