The Data Bars change – range is only 357, instead of 10357.
One simple tweak is to hide the cells’ numbers. Look at the settings in the lower section – “Edit the Rule Description”. You won’t make any changes in the “Select a Rule Type” at the top.
Here are the steps for opening the Settings dialog box: In the screen shot below, the Green Gradient data bar option was selectedĪfter you add the Data Bars, you can make a few changes to the default settings, to make the bars look better. The selected cells will show Excel Data Bars, along with the original numbers. NOTE: You can change the Fill Style (gradient or solid) later, or choose a different colour for the Data Bars.
See how to add a standard set of Data Bars (Excel 2007 and later), and adjust their settings to make the bars look better.Īnd remember to mark your calendars – next Tuesday, October 17th, is Spreadsheet Day – alert your family and friends!įirst, to add a standard set of Data Bars, follow these steps: To make a chart right in the worksheet cells, use Excel Data Bars, built with conditional formatting.