Simplifying Charts $ Graphs in Data Visualization and KPIs

Jerry Simba
2 min readDec 6, 2023

--

Combining visuals in a single graph/chart

To make your comparison visuals simpler, combining them is the way to go as it consolidates your data to communicate differences effectively.

Two, three, four, or up to a maximum of five comparisons can fit in one graph, making it simple to generate insights like time series or quick observations in case of emergencies.
Combining visuals also eliminates ambiguity and over-visualization that may make your dashboards less easy to navigate

For example, when visualizing the Total money flow of a company per year, I can combine a time series as well as a comparison analysis by using a single-column chart. check chart below

The above chart combines both Money in and Money out, a comparison within each year, and a comparison of the year by year that defines a time series of the data.

Slicer button

One thing to note is that a slicer button is NOT mandatory in a dashboard. It simply depends on how much information you’re willing to give away from your visualization.
However, it is important to note that while it is VERY EASY to add to your dashboard, it can be very useful as it allows interactivity and displays as much info when comparing different components of your dataset. It enables one to fully interact with your data.
It is important to note that it keeps your dashboard brief, precise, and appealing.

Pie chart instead of Bar chart or other charts

A pie chart is easily very appealing and I have to admit I use it often. However, to avoid misusing it, remember a pie chart MUST ONLY represent parts of a whole.
So when representing parts of a whole in your visualization, and STRICTLY for items not exceeding 5, then use a simple Pie chart

Lastly,

A line chart is the best choice to use when representing a trend.
I always recommend a line chart for MOST if not all Time series analyses. It is simple and easy to follow by the eye.

How do you simplify your visuals, comment and like, and heads up! Next article is on Why you should use either a bar or column chart, something many people find wrong but I’ll help you figure out

--

--

Jerry Simba
Jerry Simba

Written by Jerry Simba

Data. Data Journalism, Data Analyst , Data Engineer. I live in Nairobi, Kenya.

No responses yet