To make a chart right in the worksheet cells, use Excel Data Bars, built with conditional formatting. See how to add a standard set of Data Bars (Excel 2007 and later), and adjust their settings to make the bars look better.
Add Excel Data Bars
First, to add a standard set of Data Bars , follow these steps:
- Select the cells with numbers (don’t include any row or column totals).
- On the Ribbon’s Home tab, click Conditional Formatting.
- Click Data Bars, and then click any one of the Data Bar options
NOTE: You can change the Fill Style (gradient or solid) later, or choose a different colour for the Data Bars.
Change the Data Bar Settings
After you add the Data Bars, you can make a few changes to the default settings, to make the bars look better. Here are the steps for opening the Settings dialog box:
- Select the cells that contain the data bars.
- On the Ribbon, click the Home tab
- In the Styles group, click Conditional Formatting, and then click Manage Rules.
- In the list of rules, click your Data Bar rule.
- Click the Edit Rule button, to open the Edit Formatting Rule dialog box.
Hide the Numbers
You won’t make any changes in the “Select a Rule Type” at the top. Look at the settings in the lower section – “Edit the Rule Description”.
One simple tweak is to hide the cells’ numbers. This could be useful if you want people to focus on the “big picture”, rather than the details.