How to create data bars in Excel. 1. Select the cells you want to apply the data bars to. You can select a single cell, a range of cells, a table, or the entire sheet. 2.