How Do You Create A Graph In Excel?
• Enter your data into the spreadsheet in a table format with column headers, row headers and data in the middle. • Select the cells that contain the information that you want to appear in the bar graph. If you want the column labels and the row labels to show up in the graph, ensure that those are selected also. • Press the F11 button on your keyboard. This will create your a graph on a “chart sheet.” (A chart sheet is basically a spreadsheet page within a workbook that is totally dedicated to displaying your graph.) On the Chart toolbar, which appears after your chart is created, click on the arrow next to the Chart Type button and click on the Bar Chart button.
