Use Excel Data Bars To Show Your Data Visually

When you are presenting data, what’s important isn’t the data itself but what the data is saying. To help you clearly illustrate the point your data needs to make, it is usually best to represent it visually. There are a lot of ways you can do this including a variety of charts and graphs.

Excel makes a lot of this quick and easy, including the tip I’d like to share this week – data bars. Take a look at the three examples below. Which one would you rather see if you need to quickly and clearly “get it”? I think the choice is clear.

Graphbars

This type of visual formatting is easy to apply. Just select your data and look under the Conditional Formatting button for the formatting you like under Data Bars.

databarsmenu

It couldn’t be any easier than that! If you’re looking for other options for presenting your data visually check out these previous posts:

Advertisements

One thought on “Use Excel Data Bars To Show Your Data Visually

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s