How do I create a single pyramid to express %
 

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

How do I create a single pyramid to express %
 

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.
--
Cheers,
Shane Devenshire


"J_Will" wrote:

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

How do I create a single pyramid to express %
 

On Tue, 25 Sep 2007, in microsoft.public.excel.charting,
J_Will said:
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/...ngColumns.html

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.