Need idea on Visualization

Hi Revathi_Kannan 

You can use a Stacked Column Chart for this purpose, with the following configuration:

• X-axis: Countries
• Values: Count of "Present" and "Not available" from the TAX column.
• This will give you bars for each country, divided into two segments: "Present" and "Not available". The height of each segment will represent the count.
• You can enable data labels to show the exact count and percentage for each segment.

   

• Color Coding:

  • Use contrasting colors for "Present" and "Not available" (e.g., green for "Present" and red for "Not available"). This will quickly highlight countries with a higher percentage of "Not available" values, indicating where to focus for quality improvement.

With this visualization, viewers can easily compare countries based on the percentage of "Present" and "Not available" values, helping them identify areas that need attention.