How do I create a single pyramid to express %

[J_Will]

..I want to create a pyramid detailing percentage of employee levels. Eg. 5%
leadership, 30% middle managment, 75% staff. HOw the heck do I do it?

 

[ShaneDevenshire]

Hi,

Is this an accident or do you really have 5%+30%+75% = 110%?

Are you trying to do this with a chart"

If so: Enter your data in the range A1:A4 with a title in A1.

Enter 65% in A2, 30% in A3, and 5% in A4. Select the range and click the
Chart Wizard. Pick the last chart style - Pyramid and the second sub-type.
Click Next and change from Series in Columns to Series in Rows. Click Finish.

 

[Del Cotter]

I want to create a pyramid detailing percentage of employee levels. Eg. 5%
leadership, 30% middle managment, 75% staff. HOw the heck do I do it?

Stacked horizontal bar (not column) chart, with one series formatted to
be invisible. the visible series will appear to "float" to the right of
the y-axis, and so take on the appearance of a step pyramid.

This Jon Peltier article is called Floating Column Charts, but also
describes the techniques applicable to horizontal bar charts as well.

http://peltiertech.com/Excel/Charts/FloatingColumns.html