Better Visualization to Show Insights

Hi Anonymous

 

I understand the client’s difficulty with the charts in the image.

A clustered bar chart seems simple and basic, but in reality, it’s almost impossible to grasp the comparison between the countries. Our brain can only perceive the comparison within each cluster separately. When you add lines above the bars, it further challenges the reader, as there are even more elements to interpret.

Regarding the alternative: To choose the right chart for the client, we need to understand their goal—what questions they are asking and what they will do with the data tomorrow morning.

If we are talking about comparing ranges (distance between minimum and maximum, maximum and current sales, etc.), then the dumbbell chart shown in the image could be suitable.

 

 

On the other hand, if the focus is on ranking sales by country, then a table combined with a graph might help, with a separate chart for each category.

If a specific category needs to be highlighted, it can be distinguished by color.

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Hi Anonymous 

 

Here I have another idea in mind, and I would like to share it for reference.

I create a Clustered bar chart:

In the Format pane, select Bars. In the Layout box, adjust the Overlap and set the Space between series to 100%. Note that the Sort by value button should be opened to avoid obscuring data.

Open the data labels, the result is as follow:

By the way, you can adjust the thickness of the bar by changing the value of Space between categories.

 

 

Hope it helps,

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.