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.
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.
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:
- Polish Off Your Spreadsheet Work In a Jiffy with Excel’s Quick Formatting Tools
- Visualizing Your Data with Heat Maps
- Excel’s Cool Sparkline Charts
- Even more great Excel tips in the archives