next up previous home.gif
Next: Step 6: Adjusting the bars Up: Creating a Population Pyramid with Excel Previous: Step 4: Arrange the vertical axis.

Step5: Adjusting the horizontal axis

  1. Move the cursor over the horizontal axis.
  2. Right-click on it, and select Format Axis... from the pop-up menu. You will find a dialogue box titled Format Axis.
  3. Left-click on the Number tab and do the following:
    • Category: $ \Rightarrow$ Select the Custom option.
    • Type: $ \Rightarrow$ Type in 0;0 in the appropriate text box. (This will take care of the negative numbers on the male-side axis.)
  4. Left-click \fbox{OK} to exit.

horizontal_axis.gif

next up previous home.gif
Next: Step 6: Adjusting the bars Up: Creating a Population Pyramid with Excel Previous: Step 4: Arrange the vertical axis.
Copyright © 2002, Naoya Kaneko
Hosted by www.Geocities.ws

1