Display value on barchart

[#1]

Hi guys,

I have some date which looks like this:

Stuff     Target     Achieved

A          1               1

A          1               1

A          1               0

A          1               1

B          1               1

B          1               1

B          1               1

B          1               1   

B          1               1

I need to create a barchart which would tell me what's the percentage of the stuff achieved, thus, in this example the barchart would be like:

A -> 75%

B -> 100%

The problems now is that I want to display values on the chart, but instead of the percentage I want to display the number of stuff achieved in each A and B, so it would be like 3 for A and 5 for B, but I want to keep the percentage from 0 to 100 on the Y Axis. How would I do that?

Thanks,

Adrian

PS: No scrips because I can't open them

[MK_QSL]

1st Expression

Tick Bar and Values on Data Points

2nd Expression

Tick Only Values on Data Points

Remove Third Expression

[#3]

But I won't have the line anymore. I need that threshold line in there as well...

[MK_QSL]

What happens when you kept the third expression?

[#5]

Hi,

Is this the requirement /desired chart ??

[#6]

No,

In this case, the line should be "up", at 100%

[#7]

The number displayed on the bars disappear

[#8]

Thank you

Good Explanation