data visualization

How to make your charts stand out

When using a line chart to compare sales between 2 periods

Make your chart stands out does not mean making fanciful charts to attract attention although it is a plus point if you can do it.

Making your chart stands out could also be referring to emphasizing the line chart that you want your audiences to draw their attention to.

In the example given, I want to draw my audience’s attention to the line chart in 2022. Hence, I colored the 2022 line orange. The 2020 and 2021 lines are purposedly colored light with a thin line so that they could be used as a comparison and yet not overshadow the main line.

When using a Pie chart to show percentage

Most people would have squeezed all the categories into one pie chart to show the percentage contribution by category. This is not ideal as it is not easy to read.

Instead of presenting a pie chart, present each category in one pie chart. It will offer better clarity and contribution by category.

If you like, you can use a colour for each pie. This will make the categories more distinct.

Learn more about Data Visualization in our courses in Excel and Power BI.

AI Chatbot Avatar
⚠️ Welcome to our chatbot! Please note that this chatbot is designed to provide general information about our Excel and Power BI courses, and should not be relied upon as legal or financial advice. Any personal information collected by the chatbot will be handled in accordance with our privacy policy. By interacting with the chatbot, you agree to our terms and conditions.