So you’ve just finished compiling the sales figures for the big boss man and you’re ready to send it off to him, but wait there’s something missing! It’s so plain and boring. It needs some style and some visualization of what the data means. People are visual by nature so that report you spent ages compiling isn’t going to get the full attention of someone if it doesn’t also look good. In this post we’ll show you how to quickly add table styles, in cell data bars and spark lines to really make your data speak to someone.

 

Step-001-How-To-Make-Your-Data-More-Visually-Appealing How To Make Your Data Visually Appealing

 

Step 1: Add a table style.

 

Step-002-How-To-Make-Your-Data-More-Visually-Appealing How To Make Your Data Visually Appealing

 

Adding a table style is a quick and easy way to make your data stand out.

  1. Click on any cell in your data.
  2. Go to the Home tab in the ribbon.
  3. Select Format as Table from the Styles section.
  4. Select a style you like.
  5. Make sure the range selection covers all your data and if your data has column headings make sure the My table has headers is checked.
  6. Press the OK button.

 

Like magic, your table is perfectly styled and already much more appealing.

 

Step 2: Add visualization to your data with in cell data bars.

 

Step-003-How-To-Make-Your-Data-More-Visually-Appealing How To Make Your Data Visually Appealing

 

Now that the table is styled, let’s add some visualization. No one like looking at numbers when can see a picture instead.

  1. Highlight all the quarterly sales data. Leave out the totals for now as this will skew the bars for the quarter’s.
  2. Go to the Home tab.
  3. In the Styles section press the Conditional Formatting icon.
  4. In the drop down menu go to Data Bars.
  5. Select a style you like.

 

Repeat the above steps while this time only highlighting the Totals. Select a different Fill Style for the Totals to differentiate. Now you can easily see at a glance who has the most sales and in what quarter.

 

Step 3: Add spark line graphs.

 

Step-004-How-To-Make-Your-Data-More-Visually-Appealing How To Make Your Data Visually Appealing

 

To add an extra special touch let’s add some spark line graphs.

  1. Go to the Insert tab.
  2. From the Sparklines section press the Line button.
  3. In the Choose the data you want section select the first set of sales data.
  4. In the Choose where you want the sparkline to be placed section select a cell to the right of the first sales person.
  5. Copy down the cell by dragging from the lower right corner of the cell cursor.

 

Step-005-How-To-Make-Your-Data-More-Visually-Appealing How To Make Your Data Visually Appealing