population pyramid

[db_novice]

Hi all. I'm trying to create a population pyramid using access. report .
i did the chart using ms excell. I did it using stacked bar chart.
I created the same table with same fields an!d data in access. When viewing in view report mode,.it did not produce the desired output .

My x-axis is age distribution (0~9,10~19,20~29,etc). The y~axis is p
opulation by percent . male values are negative. while female values are positive.

Can anyone help?

Thanks
db_novice

 

[db_novice]

Did managed to produce the population pyramid using ms acccess report. Generally this is what i did:
1. Create a crosstab query
2. Decide which field goes to the left/right in the pyramid.
3. Field that would be on the left must have their values negative .
4. Select the chart type : stacked bar chart
5. Done.