If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the Data tab on the ribbon, and created the rule in the Data Validation dialog ...
You can easily make a pie chart in Excel to make data easier to understand. The process only takes 5 steps.
You can make a line graph in Excel in a matter of seconds using data already entered into the spreadsheet.