"Creating An Excel 2007 Chart - The Step-by-step Guide"


The Excel 2007 Chart (also known as graph) is a visual representation of numeric values. Displaying data in a well-conceived chart can make your numbers more understandable.

The Excel 2007 charts have a great new look. That is why today Excel is one of the most commonly used application for creating charts.

Before you can create a chart, you must have some numbers (data) that stored in the cells in an Excel worksheet. Normally, the data that a chart uses can be resides in a single worksheet, or use data that's stored in other worksheets.


Creating an Excel 2007 Chart from Data in a Worksheet

Once you have entered the data you want to display as a chart into a worksheet and decided which type of chart you require, you can create it with just a few mouse clicks. Use the following illustration to quickly create a chart on the current worksheet.

Open Excel 2007 and create a worksheet as illustrated below.

Excel chart 2007 worksheet


To create a chart

  • Click on any cell within the data containing the information that you wish to display as a chart, or highlight the exact data area that you wish to display as a chart.
  • On the Insert menu, in the Charts group, click the chart type you require. A gallery of thumbnail images for the related chart subtypes will appear.

Excel 2007 Chart type gallery

  • Click the required chart subtype to create the chart, or click All Chart Types to open the Insert Chart dialog box and choose from all available chart types.
  • When you have selected a subtype, a chart will be created as an object in the worksheet and Chart Tools will appear on the Ribbon incorporating Design, Layout, and Format tabs.
  • For example, when choose the '3-D Clustered Column' subtype, the chart created as follow:

3D Clustered Column Chart

  • Alternatively, click the Charts group Dialog Box Launcher to open the Insert Chart dialog box and see all the available chart types.

Excel 2007 Insert Chart dialog box

  • You can also change the default chart type in the Insert Chart dialog box by selecting a chart type and clicking the Set as Default Chart button.

Note: To quickly create a chart of the selected data (based on the default chart type) as an object in the current worksheet, press Alt+F1. To create a chart of the selected data as a new sheet, press F11.


Creating an Excel 2007 Chart from Data in a Different Worksheet

It is possible to display a chart on one worksheet using data from a different worksheet. The source data can even come from a separate open workbook.

To create a chart using data from a different worksheet, do the following:


To create a chart (data in another worksheet)

  • Click a blank cell in the worksheet that you want the chart to be displayed in.
  • From the Insert menu, in the Charts group, click the chart type and subtype you require.
  • Select the Design tab under Chart Tools on the Ribbon and click Select Data in the Data group.

Excel 2007 select data source

  • From the Select Data Source dialog box displayed, enter the data range that you want to use for the chart in the Chart data range: box by clicking the Collapse Dialog icon to the right of the Chart data range: box and selecting the workbook and/or worksheet and then the cell range that you want to use for the data source.

Excel 2007 select data source

  • Click the Expand Dialog icon to the right of the Select Data Source dialog box when you have finished.
  • Alternatively you can type the data range into the Chart data range: box following the following formats:
    >> Type the format Sheet2!$A$8:$C$12 if you are charting the data in cells A8 to C12 in Sheet2 of the current workbook.

    >> If you want to use data from a sheet (Sheet1) in a different workbook (Workbook2), the format would be [Workbook2]Sheet1!$A$8:$C$12.

    If the name of either the worksheet or workbook contains spaces, enclose the workbook / worksheet name in single quotes,'[Sales2007]Jan Sales!'$A$8:$C$12.

  • Click OK to close the Select Data Source dialog box.


Related Topics:

Guide to Creating and Formatting the Excel 2007 Chart Legend
Creating and Formatting the Excel 2007 Chart Title
Step-by-step guide to Create a Pie Chart in Excel 2007?
How to Make a Histogram with Microsoft Excel 2007?



Can't find what you're looking for? Try Google Search!

Custom Search


Back to Top

You're viewing the Excel 2007 chart info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.