How To Make Your Data Visually Appealing

2016-12-16

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

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps and SharePoint. You can find other interesting articles from John on his blog or YouTube channel.

Subscribe

Advertisement

Related Articles

37 Awesome Excel Mouse Tips & Tricks You Should Know

37 Awesome Excel Mouse Tips & Tricks You Should Know

While the keyboard is generally quicker, you shouldn’t completely ignore the mouse. There are also some great time saving mouse shortcuts as well. In this post we’ll take a look at some of the best Excel mouse time saving tips and tricks.

read more
25 Amazing Power Query Tips and Tricks

25 Amazing Power Query Tips and Tricks

Power query is amazing tool that allows you to import and transform data with ease and helps to create repeatable and robust procedures with your data. Here are some tips and tricks to help you get the most out Power Query.

read more

Comments

2 Comments

  1. WALID IBRAHIM

    MANY THANKS

    Reply
    • John

      No problem, I’m glad these tutorials are helpful!

      Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Get The Latest News

Follow Us

Follow us on social media to stay up to date with the latest tips in Excel!

Pin It on Pinterest

Share This