8 Best Chart Formatting Practices
Today, I am going to give you some killer formatting tips to make your charts look absolutely stunning (you can literally compare them to the best looking girl your office!!). Let’s get started

 

1. Remove Gridlines and Axis if not necessary

8 Best Chart Formatting Practices 2

Take a look at this chart and answer the questions?

  1. What was the revenue in 2003 ?
  2. Revenue in 2008 ?
  3. And Revenue in 2010 ?

I guess even the blond can answer these, since the values are straight on top of the bars. So why do you need the axis and gridlines? Remove them if unnecessary

  1. The purpose of the Axis is to get an approximate value of the bar’s height
  2. And gridlines help you match the bar height to the axis values

Both these become unnecessary and occupy space when you have data labels

 

2. Fade off Axis Labels

8 Best Chart Formatting Practices 3

Look at the 2 charts above.

The Faded (lighter colored) label does the job as good as the dark labels. Remember the Axis Labels are just meant to help you understand approximate values for the chart. The darker they are the more attention they will grab, so fade them with grey color

 

3. Legends are not needed for a single data point

8 Best Chart Formatting Practices 4

In the Chart above it is pretty evident that the bars show revenue. Why do we need a legend for that when the Chart title is pretty convincing. If your chart has just one data point, remove the legend.

In the newer versions of Excel (13 and above) the legends are taken off automatically in case your charts only have a single data point.

 

4. Match the color of Data Labels to the Bars/Lines

8 Best Chart Formatting Practices 5

Which of the 2 charts above is easier to read? It becomes incredibly easy to read the chart with matching data labels colors (take a look at the 2nd chart)

 

5. Align the Axis Labels Properly

8 Best Chart Formatting Practices 6

You cannot expect the reader to tilt her neck while reading your chart. That would be awful and too much to expect. So align your Axis Labels to fit Horizontally or Vertically

 

6. Say NO to unnecessary Borders

8 Best Chart Formatting Practices 7

Okay, think about this!

In your living room, do you draw a border outside the edges of the TV on the wall to mark the area for TV? No you don’t.

The reason we use borders and outlines is to group or isolate things from one another. If not needed get rid of unnecessary borders and outlines. It will help you get a cleaner and clutter free chart

 

7. Write Inference Based Chart Titles

8 Best Chart Formatting Practices 8

Read the Chart Titles of the both the Charts. The second chart title definitely gives a deeper perspective than the first one. Next time you make a chart make sure that you put a meaningful inference based title to draw deeper meaning out of your chart. It is just 10 seconds of extra work but gets a ton of appreciation, trrrust me!

 

8. Avoid Indirect Legends

8 Best Chart Formatting Practices 9

Take a look at the above charts. I guess you would agree with me that Direct Legends are much easier to read and interpret quickly. Here is how you can apply direct legends

While Indirect Legends make it difficult to instantly interpret the data. Try and stick to simple and direct legends as much as possible

 

Share your best chart formatting practices..

If you have liked any of the above best practice or have your own best practice, please put it down in the comments below. I would love to hear what makes beautiful women envy your charts 😉

 

Some More Charting Guidelines

  1. How to Pick up the Right Color for your Chart?
  2. Quick Tip – Customize Markers in your Chart
  3. Copy Chart Formats in one Key Stroke
  4. Create Chart in 1 Key Stroke

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI