To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.
To do this, with the 1% cell still copied, select the cells containing the values you want to convert from whole numbers into percentages. If your data is formatted as an Excel table, hover over the ...