Displaying different chart values

[cfunkho]

I have a bar chart (see attachment) that showing a percentage.  Above the bars, I have the percentage value displaying.

However, what I'd like to display above the percentage bars is the numerator of the percentage.  The percentage is a data item in which both the numerator and denominator are data items in the query as well. 

Is it possible to display a different data item above the percentage bars? 

Thanks,
Chris Funkhouser

[CoolP]

Hi,
There is a way to do it. Add 'Numerator' as another Series(Bar) to your chart. Then go to chart properties and change the property 'Series Color' to 'Match'. Display the values for both the series. Choose the foreground appropriately so that the values are visible.May be you may have to display the percentage in the bottom of the bar and the numerator on top. You may also want to customize the title for the axis.

Hope this helps.

Cheers
CP

[cfunkho]

Thanks.  I tried what you said, but I always get multiple bars (one for the percentage data point, and one for the numerator data point).  Is there a way to do this while only showing the bars for the percentage data point?  I figure I'm missing something...

[CoolP]

Yes, you are missing the 'chart grouping' setting. Click on the 'Series' and then in the properties set the  'chart grouping' property to 'stacked'. This should resolve your problem.

Cheers
Prasan