yogi_Make A Population Chart In Google Docs Spreadsheet -- A Formula Based Solution

                                         Google Spreadsheet   Post  #1570
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-22-2014
post by whsigs (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/rBdJETOE14Q)
Making a population pyramid by reversing the bar chart so the axis is on the right
'm accessing Google Docs on Google Chrome

I am trying to make a population pyramid with sheets. A population pyramid looks like this:  http://upload.wikimedia.org/wikipedia/en/6/6a/Population_pyramid_example.svg

As you can see, it is essentially two bar charts facing in opposite directions.  I have made a sheet to calculate the data which is here:  https://docs.google.com/a/weldre4.k12.co.us/spreadsheet/ccc?key=0Aixg512qAqFgdHZMU25SUExtNEZKUmcydGM2YVhCTmc#gid=0

The problem with sheets is that I cannot see how to make the male side of the pyramid which is the reversed bar chart.  I have an excel template that does this but I would like to try to keep this on Google Drive for better sharing access and to embed in a site.

Thanks,

Steve

--------------------------------------------------------------------------------------------------------------------------------------------------------

I present tin the following a formula based solution