Inside Microsoft Excel

Track your growth with a simple, one-cell progress bar

Inside Microsoft Excel

by Kara Hiltz

Although in-cell bars with conditional formatting originated in Excel 2007, that version offered only gradient bars. Excel 2010 has added a slightly new feature- solid bars. These solid bars look a bit more like traditional bar charts and you can use one color instead of choosing between a two-color or three-color scale. One-color solid bars look more clear-cut, as shown in Figure A.

Setting up a spreadsheet with one-cell progress bars is just[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)