4 of 4 people found this helpful
Follow the below steps to get the Correct O/p
Step 1: Click Calc field 1 and show header
Step 2: Click on header --> edit axis and change the axis range from 0 to 2 to 0 to 1
Step 3: Change the marks section to bar
You will get your required O/P
Hope this helps kindly mark this answer as correct or helpful so that it will help others
6 of 6 people found this helpful
(1) In the all tab, Put Country to color only.
(2) in the Sum(Calc Field Text) tab, adjust the transparency of color to 0.
(3) Change to Bar chart.
When you adjust the height of the square, it will always keep same heights for each country. Please see screenshot and workbook.
Hope it helps.
This is perfect, thank you so much Naveen!
Hi Michael, thank you for your response. I have to stick to a pre-defined colour-coding red-yellow-green, depending on the rating of the country. Unfortunately your solution does not apply to my problem. If you are interested, see how Naveen solved it.