How do I create a single pyramid to express %

G

Guest

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

Guest

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

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?
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pyramid Charts 1
Population Pyramid and Negative Numbers 3
How can population pyramid made in excel ? 1
Need help on a Query Calculation 1
how do I to put a 3 part pyramid in a presentation 1
How do you make a population pyramid in excel? 1
Pyramid diagrams - like food pyramid - How can it be done? 2
How do I create a population pyramid? 1

Top