word-excel-access-help.com logo
Excel Charting
Home
Word 2007
Excel 2007
Access 2007
Word xp
Excel xp
Access xp

Additional Resources







Excel Charting | Microsoft Excel XP | Page 4

Microsoft Excel XP logo
Learn step-by-step how to do Excel charting from scratch in four easy steps using the Chart Wizard.

Excel Office Helper What's on this page...
Using the Chart Wizard
Chart Wizard - STEP 1
Chart Wizard - STEP 2
Chart Wizard - STEP 3

Chart Wizard - STEP 4
Changing the Chart Type
Changing a Chart's Location

See also...
Charts
Modify Chart Elements

Chart Wizard: STEP 4 of 4

In Excel charting in Step 4 of the Chart Wizard, you specify where you want the chart to display.

You can display it as a new chart sheet or as an object in an existing worksheet where you can select the sheet.

  Excel Charting: Chart Wizard - Step 4: Chart Location
   
1. Specify the Location of your chart.
   
2. When you click FINISH, Excel creates the chart per your specifications.


Changing The Chart Type

Excel charting supports a wide variety of chart types that you can choose from for example, line charts, column charts, and so on.

To change the chart type, follow these steps:

1. Activate the chart.
   
2. Choose Chart ► Chart Type from the menu bar to display the Chart Type dialog box.
   
3. Click the desired chart type.

You can select from standard chart types (in the Standard tab) or custom chart types (listed in the Custom tab).

You'll see a preview of how your chart will look.
   
4. When you're satisfied with the chart's appearance, click OK.

The chart types displayed in the Custom tab of the Chart Type dialog box are standard chart types that have been modified in one or more ways.

Excel comes with a variety of custom chart types, and you can create your own.

Another way to change the chart type is to use the Chart Type button on the Chart toolbar.

This tool displays the major chart types (you cannot select custom chart types). 

Excel Charting: Chart Type button


Excel Office Helper
If you've customized some aspects of your chart, choosing a new chart type may override some or all of the changes you've made.

For example, if you add gridlines to the chart and then select a chart type that doesn't use gridlines, your gridlines will disappear.


Changing A Chart's Location

When doing Excel Charting with the Chart Wizard, you are given a choice between placing your chart on the same sheet as the data or on a new worksheet.

If your chart is embedded on a worksheet, you can click a border and drag it to a new location on the worksheet.

To move the embedded chart to a different sheet or to a separate chart sheet, select the chart and choose Chart ► Location from the menu bar.

Specify the new location of the chart and click OK.
 
See also..  Charts  |  Modify Chart Elements
 
Back to Top
 
Return to Excel XP from Excel Charting
 
Excel XP Topics
- Tips
- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Print
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter