How To Make Your Data Visually Appealing

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

 

Step 1: Add a table style.

 

step-002-how-to-make-your-data-more-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

 

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

 

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

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.

Related Posts

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

    • John

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

Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃