"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.
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.
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.
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:
>> 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.
Guide to Creating and Formatting the Excel 2007 Chart Legend
Recommended Books:Click on the image to view the details of the book.
The Ultimate Guide to
The Ultimate Guide to
Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?
| Home | Excel 2007 Tutorials | Word 2007 Tutorials | PowerPoint 2007 Tutorials | Outlook 2007 Tutorials |
| Free Templates | Free Clip Arts | Free Tips & Tricks | Free Keyboard Shortcuts | Office 2003 Books |
| Excel 2003 Tutorials | Word 2003 Tutorials | PowerPoint 2003 Tutorials | Outlook 2003 Tutorials |
| Office 2010 Tutorials | Excel 2010 Tutorials | Word 2010 Tutorials | PowerPoint 2010 Tutorials |