Chart for company activity/pinchpoints
 

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...

Chart for company activity/pinchpoints
 

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

Chart for company activity/pinchpoints
 

Andy,
Thanks for your reply - I had a look at your website, and I could use
something like this. I'd like to use bar charts so activity can be viewed as
discrete blocks of time against the year. Almost need a stacked bar chart (to
account for overlap of peak activity in different departments) but the
durations of peak wouldn't be the same...

Also thanks for your reply yesterday about radial diagrams - I'm still
thinking about the best way to do this as they need to be easily maintainable
(eg add circles on as new tasks come up, change the color coding as projects
progress, alter the positioning of the circles)... at the moment I've got a
word document with each circle hyperlinked to a seperate comments sheet
detailing the projects aims and outcomes etc... and I was just getting a bit
fed up of manula adjustments, and liked the automatic circle spacing on the
standard radial diagram in Excel.

Thanks for your input, Mel

"Andy Pope" wrote:

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