To apply data validation rules to a selected cell or range, head to the "Data" tab on the ribbon, and click the top half of ...
To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.
You can easily make a pie chart in Excel to make data easier to understand. The process only takes 5 steps.