Add % on top of a chart

[ttal7878]

Hi,

The attached charts shows sales by salesman devided to open sales and closed sales status

I would like to add on top of every chart the open sales percentage

For example, if salesman B has 11 closed sales and 100 open sales

we should get 90% open sales (100/111)

Is it possible?

[stabben23]

Something like this?

[stabben23]

added qvw

[ttal7878]

thank you,

Is it possible to add the values - sales quantity with open status and sales quantity with closed status on the graph

[stabben23]

To use it inside the segment is a tricky one because of Your need to show % and number togther.

This maybe fill Your requirement?

[ttal7878]

Thanks Staffan, can you upload the script please

Maybe you have another idea? Maybe adding another graph to show the percentages?

[stabben23 · Accepted solution]

here is qvw, I have a look what I can do.

[ttal7878]

I've tried something similar, but the percentages displayed on the axis do not appear clearly, do you know why?

[stabben23]

Yes,

Count Sales should have Text on Axis checked.

% should have Values on Data Point checked.

Also untick Plot Values Inside Segment on Presentation tab

[stabben23]

Ok, maybe missunderstod here, you want % where you have it in you pic?