Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
1st Expression
Tick Bar and Values on Data Points
2nd Expression
Tick Only Values on Data Points
Remove Third Expression
But I won't have the line anymore. I need that threshold line in there as well...
What happens when you kept the third expression?
Hi,
Is this the requirement /desired chart ??
No,
In this case, the line should be "up", at 100%
The number displayed on the bars disappear
Thank you
Good Explanation