Saturday, March 22, 2014

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   Mar-22-2014
post by whsigs (!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:

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:

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.


I present tin the following a formula based solution