Paul wrote
So instead of 45.6% you would display 387 for the 0-13 age range- but show 45.6 for contactable and 54.4 for the not contactable -- correct? if so, this is not possible in a single chart with SQLChart. You could create this with the Charting Engine, but this would require coding a specific module.
Yes, for the 0-13 age range, the y-axis would show 847, the first part of the stack would be level with 387 on the y-axis but would show a data label of 45.6%, the top part of the stack would rise between 347 and 847 and the data label would show 54.4%
Paul wrote
To create the percent chart you could just calculate the percentages in the select ... and then display that ... all the bars will then be the same height (100%) ...so not quite sure this is what you are after.
It might not be exactly what I'm after, but it would show the relative percentages per age range, so I'll do that in another chart just below the original chart, then persuade the customer that it's a better way of showing it ;)
Thanks Paul.
Barry