If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 ...
You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.
To add a formula in Google Sheets, click the cell where you want the answer, then choose one of the hundreds of functions.