Microsoft Excel – Adding data bars

In this tutorial we will be adding data bars to cells within our Excel spreadsheet, data bars are useful in providing us representing the values within our cells as well as give us an idea of the variation and range.

To add data bars to your Excel spreadsheet carry out the following steps.

  1. Highlight the cells for which you are wanting data bars displayed.
  2. With the cells highlighted click on the ‘Home‘ tab and then click ‘Conditional Formatting‘.
  3. Within the dropdown select ‘Data Bars‘ and preferred data bars i.e. gradient or solid filled.

Your data bars will then be displayed within the selected cells with the relevant gradient or solid filled colour applied.

Leave a Reply