How to create LOW MEDIUM HIGH bar chart with Y-axis 0-100% & number value in the data points

[jim_chan]

Hi guys,

I need to create a bar chart as below, has anyone done it before? any advise?

- i have a top 20 list - field = top_list dimension & 1 rating (low, medium, high) dimension

- 1 expression, count(record_number)

- each of the bar must up to 100%

- the low medium high segment short and long , depends on the count of record number. 

Rgds

Jim

[Frank_Hartmann]

There is no native QV Option to show absolute numbers within a percentage axis! Thats why you need to create an extra transparent chart with invisible expressions and overlay this to the existing chart!

See attached file for workaround!

hope this helps

[jim_chan]

i saw your qvw file.  u r using expression:

(count({<Rating={'HIGH'}>}Category))/count(Category)

y cannot (count({<Rating={'HIGH'}>}Category))/count( TOTAL Category)

???

[Frank_Hartmann]

that was just to get the proportions and the percentage axis for the transparent chart.

Perhaps the attached solution might be better but the probleme will be to fit the absolute numbers to the

corresponding bar. perhaps someone has a better solution....

[vinieme12]

USE a DUAL expression, there is no need to overlay a transparent chart

can you post a data sample to demonstrate

[vinieme12 · Accepted solution]

see attached