There are many things you can do under conditional formatting in excel and creating data bars is one of them.
Data bars in ms excel are a perfect tool to visualize numbers to be able to differentiate quickly. When you apply data bars formatting to a set of data in your excel spreadsheet it creates a bar in each numeric cell to represent the number. The higher the number. the longer the data bar appears in the cell.
Using data bars businesses can quickly track their best selling products and least selling products or the month with most sales and least sales.
How to Create Data Bars
Execute the below steps to be able to create data bars in your Microsoft Excel file:
Select a set of multiple cells or an entire spreadsheet that you want to represent using data bars
Click on Conditional Formatting > Data Bars
Now select a Colour to visualize your data
Subscribe to my YouTube Channel for more MS Excel Tutorials. Click here to subscribe.
Need help with some one time or ongoing Excel file / database management work. Contact me email@example.com
More MS-Excel Tutorials
But before we discuss How to back up your Gmail emails please Subscribe to my newsletters to gain unlimited access to my freebies library