I want to create a population pyramid in Tableau for many states in my country. Somewhat like Jorge Camoes': http://www.excelcharts.com/blog/beautiful-but-terrible-pyramids-tableau-edition/
I have been able to create the pyramid for a single state. I know I can add the info from the other states by manually adding columns to the chart, but I am sure that there is another way to do it if the data is well formatted. Any suggestion on this? Currently I have one excel sheet per state with "age" and "population" attributes.
Answering to my own question here:
Instead of having one sheet per state, I added a "state" attribute and imported all data in a single sheet. I ended having the following attributes (amog others):
<Age bin> <Female> <Male> <State>
That did the trick.