I’m reposting my population pyramid template since the original file was deleted when I converted to WordPress. This template was originally discussed through my post on MyXcelsius.com which can be found here.
The key to this trick is to use negatives for the male distribution and to use a custom Excel format to remove the negative sign from the format before linking the values in the chart. The custom format would look like this: 0.0%_);0.0%
File was prepared with Xcelsius 2008, version 184.108.40.206