Show percentages with a little color (Excel 2007)

Welcome to New Horizons!

With 300 centers in 70 countries, New Horizons is the world’s largest independent IT training company. Our innovative, award-winning learning methods have revolutionized the way students learn, retain and apply new knowledge; and we offer the largest Guaranteed-to-Run course schedule in the world.

Our real-time, cloud-based lab solution allows students to access their labs anytime and anywhere. And we offer an extensive selection of vendor-authorized training and certifications for Microsoft, Cisco, CompTIA and VMware, ensuring that students are able to train on the latest products and technologies. Over our 30-year history, New Horizons has trained over 30 million people worldwide.

Percentages interpret your data as smaller parts of a larger piece. This is why pie charts are often a popular way to demonstrate percentages. However, if you want to conserve space and still present an attractive, effective visual of your percentage data, Excel 2007 offers a great alternative.

On the Home ribbon, in the Styles panel, there’s a Conditional Formatting icon that opens a shortcut menu. In this menu, you’ll see a formatting option called Data Bars. When you select a data range and then apply data bars (in any of a wide range of colors), the bars visually demonstrate the percentage or number in comparison to the other numbers in the data range. If you widen or contract the column’s width, the data bars remain proportionate.

The best part about the data bars is that they take seconds to apply — but it looks like they took hours of careful formatting. Print this post

Welcome to New Horizons!