One key aspect of working with data is, not only to be able to identify trends in the dataset, but also to present the data visually for the user to see and understand it better. One easy way is to add data bars in excel. 

Data bars in Excel is a great visualization tool that will enhance the readability and understandability of your dataset. It is one of Excel’s powerful visualization tools in conditional formatting options and it is used to visually present values in a range of cells using bar lengths.

Here is an example of one used below.

The data bars relate to the values in each cell. When the value in the cell is large, the bar will be longer and if the bar is shorter, it means that the value in the cell is smaller.

This way, you can easily identify the items with the highest numbers that was delivered and the destination.

And when the values in the cells change, Excel will automatically adjust the bars.

Although, data bars is one of Excel’s advanced visualization tool, it is very easy to create with just a few clicks.

So, to add data bars to your worksheet like the one above, here are the steps that you should follow:

1. Select the cells to apply the data bars to.

You can either select a single cell, a cell range, a data table or the entire worksheet.

2. Go to Home tab -> Conditional Formatting

3. Click on ‘Data Bars’ and select your preferred style.

You can select from either the Gradient Fill or Solid Fill options.

You may decide to enhance the data bars further if you want to.

You will need to click on ‘More Rules’ to enable you customize the bars in the dialog box that pops up.

The default setting is set to ‘Format all cells based on their values’ but you can go for other options like ‘Format only cells that contain’ and then specify a numeric range where the bars will appear.

After editing, click ok.

I hope you found this article useful. I would love you to share your thoughts in the comment section.

15 Replies to “How To Create Data Bars Using Conditional Formatting in Excel”

Leave a Reply

Your email address will not be published.