Age pyramid

[Licenses]

Hey,

We are looking for a special chart type or a way to make an age pyramid.

The following link shows an example of the chart we are looking for.

http://www.infovis.net/imagenes/T1_N158_A841_AgePyramid.gif

Is there any way to create a chart like this ? 

Thanks
Sodi We

[Peter]

Hi Sodi,

Check out the attached sample report definition I have used the AdventureWorks database, thus you may have to modify the connection string. Here are the required steps to setup age pyramid chart type:

1. From the Insert tab start the Stacked Bar Chart wizard;
2. Set up the datasource;
3. Set Gender field for Series;
4. Set Years field for Categories;
5. Set Count(Fields.Years) expression for Value;
6. Click Finish;
7. Now you have to make some changes with the Property Window;
8. Select the Graph Series and change the Series X value expression =Count(Fields.Years) to =IIF(Fields.Gender = "M", -Count(Fields.Years), Count(Fields.Years))  ;
9. Select the Graph X Axis and set the LabelFormat to {0:##;##}  . This will remove the minus sign from the axis labels;
10. Optionally if you want the Y axis to show age ranges, you can change the CategoriesGroups (yearGroup1) Grouping expression as we have done.

All the best,
Peter
the Telerik team

[Jack]

Thanks, this helped me get a working example going fairly easily.  I ended up using {0:#,#;#,#} for the LabelFormat option.  This adds commas to the axis value labels.