Pyramid/Hierarchial graph/chat in Excel

Pyramid/Hierarchial graph/chat in Excel

Didn't find your answer?

I work in a professional services firm and want to put together a graphical representation of our staff structures by business unit. Typically these will be a pyramid (a few senior staff, reasonable number of middle ranking staff, loads of junior staff) albeit different services lines would be barrel or funnel shaped in their staff mix. What I want to know is if / how can I put this in a graph in Excel. The key is showing the size of a particular grade horizontally (and centred), while showing vertically the same graphical size or space for each grade. Any ideas how I can do this?
Chris Jones

Replies (3)

Please login or register to join the discussion.

avatar
By lynnecart
19th Jan 2006 12:11

On the contrary....
.... this is simple. In column B (e.g. rows 1 to 5) enter the number of staff in each grade. In cell A1, enter the following formula:

=IF(MAX(B$1:B$5)=B1,1,(MAX(B$1:B$5)-B1)/2+1)

Copy this formula to cells A2 to A5.

Then select your 10 data cells and generate a nice horizontal "tube" graph (one of the "custom" types in the Chart Wizard). Set the border and fill of the first series to be transparent, delete the labels and the X-axis and Bob's your uncle.

Thanks (0)
avatar
By User deleted
10th Jan 2006 17:15

Try Visio
Visio can also be driven by external data

Thanks (0)
avatar
By neileg
10th Jan 2006 13:27

Horses for courses
I use Org Plus for this. An absolute doddle. You could spend days getting Excel to produce anything similar.

Thanks (0)