Visualization Tips for Data Analysis Download the hi-res PDF: bit.

ly/viztipspdf

Download the hi-res PDF: bit.ly/viztipspdf

1 Choose the right chart: Make data fast to interpret and insightful Choose the Right Chart Masterclass

Column/Bar Chart Line Chart Scatter Plot Pie/Donut Chart:

When? Best Practice: When? Best Practice: When? Best Practice: When? Best Practice:

- Sort data by value. Compare data over Plot the dependent Show parts of a whole. Only use when you
Compare data across Do not overload with too Show correlation
- Always start vertical time or sequential variable on the vertical (Alternatively, use Pie have 5 or less
categories (or time). many lines. between two factors.
axis at zero. categories. axis Chart.) segments.

2 Simplify your charts: Remove clutter - less is more 3 Use Conditional Formatting: Highlight important points
Step by Step:
Chart Formatting Masterclass
Top 10 Tips:
1. Create new conditional columns
1. Remove gridlines using the IF function for the
2. Remove redundant legend columns to highlight – in this
3. Hide all field buttons on chart
4. Remove cluttered axis
example, the max and min values.
5. Reduce gap width between bars 2. Insert a Clustered Column Chart.
6. Sort Smallest to Largest 3. Format the max and min series
7. Add & format data labels columns with a unique color.
8. Scale data label values to K, M, B etc. 4. Add data labels if desired.
9. Make chart title more meaningful
10. Remove axis tick marks The chart will automatically highlight
the maximum and minimum values as
the data changes.

Format Max and Min

Enroll values with custom

number format that

Now!
hides zero values.
https://bit.ly/moth-courses

https://bit.ly/ Updating data updates

moth-courses the chart, with
conditional formatting.

4 Use Slicers: Make your charts interactive Min-Max Chart

Masterclass
All Data:
Select slicer values to
filter for high LTV
5 Use Sparklines: Visualize large datasets
customers
How? Benefits:
Filtered Data: Select the destination cells > Insert tab > 1. Reduces chart clutter when
Sparklines group > Columns > Select the data range data has too many data points.
2. Perfect for summaries or
dashboards where space is
limited.

Sparklines are
in-cell mini charts.

Bubble size
How? represents LTV
Format chart data in a table > Insert
Tab > Slicer > Select filter criteria Slicers Masterclass Sparklines Masterclass

Mynda Treacy
TEACHING YOU CAREER TRANSFORMING SKILLS Follow me for tips and tutorials

© Copyright 2025 Follow me for tips and tutorials