View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default 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?