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

Step 7: Dressing up

You can modify the chart to eliminate grid, change color, change the legend, and do anything until you feel it's right. In addition to suppressing the legends, I will add text boxes now. In order to add a textbox, select Text Box on the drawing toolbar.
drawing_toolbar.gif
If you don't find the drawing toolbar, you need to enable it (Tool $ \Rightarrow$ Customize... $ \Rightarrow$ tick the box for Drawing).

Once you click on the text box icon and move the cursor over the chart, you will find the cursor has a different look. Place the cursor where you want to make a text box, hold the mouse key, drag the cursor, and release the mouse key to make a text box of your preferred size. Now enter the text in the box.

add_textbox.gif
Personally I feel the following chart will do.
finished.gif

See? It's easy, isn't it? Now it's your turn to create your pyramid.
Enjoy!
(Data Source: U.S. Census Bureau, International Data Base.)

[Back to Economic Focus ]
next up previous home.gif
Up: Creating a Population Pyramid with Excel Previous: Step 6: Adjusting the bars
Copyright © 2002, Naoya Kaneko
Hosted by www.Geocities.ws

1