How to Create a Graph in Excel 2007

By Erika Dean

When you create a report using Excel, it is useful to insert a graph--called a chart in Excel--to provide a visual representation of your data. It takes little time to create a graph in Excel and there are many types of graphs to choose from. After you select the data you want to display, you can create the graph with a few clicks of the mouse.

Step 1

Open the Excel spreadsheet in which you want to add a graph.

Step 2

Arrange the data you want to display in a graph in rows or columns. Make sure to add a title to the rows or columns. After you arrange the data, use your mouse to highlight the data to insert in the graph.

Step 3

Click the "Insert" tab located in the Excel ribbon and look to the "Charts" section. There are several types of graphs you can choose from, including line, pie and scatter graphs.

Step 4

Click the graph type you want to create. A drop-down menu will open with several options you can choose from. For example, if you want to insert a bar graph, you can choose to insert a 2-D or 3-D graph.

Step 5

Click the chart you want to insert; the chart will appear on your spreadsheet and display the data you selected.

Tips & Warnings

  • After you create the graph you can change its style or color by right-clicking over the graph and selecting "Format Plot Area." The "Format Plot Area" dialog box will open and you can begin customizing the chart.

References & Resources