Home » Resources » Excel 2007 Tutorial » Creating charts

Excel 2007 can create a range of graphs and charts based on data in your spreadsheet, including line, column, area, line, pie, scatter, and bar charts.

Once created, Excel graphs will automatically update to represent any changes in data that you may make.

Before we start you’ll need a set of data so that you can give Excel something to make a graph out of.  Copy the data shown below, or use something similar that’s relevant to you.

Using this example, highlight cells A5 to D8, i.e. all the information in the table apart from the total sales and the title. After you have highlighted the cells, click on the insert tab at the top of the ribbon which will give you a range of graph and chart options – select “column chart”. You will now be presented with a list of column charts to choose from, select the “Clustered chart”; this is the first one in the list under the 2D section.

The following basic graph will appear containing the relevant information:

Similar resources you may like

1. Altering and Moving your chart
2. Moving a Chart To a Chart Sheet
3. Changing Your Chart Layout
4. Changing Your Chart Style
5. Changing Your Chart Type

Tags

chart, creating charts, Excel, Excel 2007 Tutorial, excel chart, excel training, excel tutorial, Free, microsoft, microsoft excel, microsoft office, resource, Tips, top Tips, training, what is column chart

Share This Resource

This entry was posted by Alistair Wylie on Wednesday, May 6th, 2009 at 1:00 pm and is filed under Excel 2007 Tutorial. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.