How to Make a Column Chart in Excel

1.
Find the file that contains your data and open it in Excel. If you still need to enter your data, open a new workbook instead. Input your data into a spreadsheet in the new workbook. As an example, we will create a small table containing data on the number of books bought at a yard sale. We will categorize the books by genre.
2.
Highlight the cells in the spreadsheet that contain your data. For our example, the cells A1-B8 have been highlighted.
3.
Choose the “Column” chart option from the “Insert” menu on Excel’s toolbar. Pick the type of column chart that you want to create. We will choose the side-by-side, non-stacked 3-D column chart for our example.
4.
Review the column chart that you have just created. Make any desired modifications to the chart. You can change the colors, wording of the title, location in the spreadsheet, and font used in the chart. Don’t be afraid to experiment! If you do make a change that you don’t like, just use the “Undo” option to get rid of the change.
5.
Save your file as an Excel workbook.