How to Make a Bar Chart in Excel

1.
Open the Excel file that contains your data. If you have not created a file with your data yet, open a new Excel workbook and do that now. In this example, there is e a small list of data detailing how many people chose various animals as their favorite to use as an example.
2.
Use your mouse to highlight the cells that contain your data. In this example, cells A1 through B7 are highlighted.
3.
Choose the “Insert” menu from the toolbar in Excel. Now choose the “Bar” chart submenu. Pick which type of bar chart you would like to create. For the example, use the simplest 2-D version.
4.
Look over the chart you created and decide if you want to make any changes to the format. Feel free to experiment here. If you try something and find that you don’t like it, you can always use the “Undo” key to return to your file’s previous state.
5.
Save your file so that you don’t lose your work.