Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Fonlovedog207
Contributor
Contributor

How to create graph % and value in one graph

I want to create this graph

Fonlovedog207_0-1671506730134.png

but 

1. % and value overlap

2. Gap between % and value

Fonlovedog207_1-1671506943376.png

 

Labels (4)
1 Reply
rubenmarin

You can try using Dual() for the dot expression, the first parameter for the value to show, the second to position the dot like:

Dual(Num(%Expression,'0%'), BarExpression*1.2)

The *1.2 may not be accurate, more complex expression will be needed to keep the same distance, maybe using a variable to calculate the value of the larger bar and from there a fixed numeric distance to use in all bars