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

Additional Resources

Excel Charting Elements | Microsoft Excel XP | Page 2

Microsoft Excel XP logo
Learn step-by-step how to modify all the Excel charting elements of a chart.

Excel Office Helper What's on this page...
Dealing with Chart Elements
Modify a Chart Element
Move a Chart Element
Deleting a Chart Element
Chart Basics
Adding a new Data Series to a chart
Changing the Chart's Data Series
Working with chart Legends
Changing a chart's Scale
Changing a chart's Gridlines
Rotating and Elevating a 3D Chart

See also...
Excel Charts
Excel Charting with the Chart Wizard

Moving A Chart Element

Some of the Excel charting elements can be moved (any of the titles, data labels, and the legend).

To move a chart element, follow these steps:

1. Select the chart element you want to move.
2. Click the border of the element and drag it to the desired location in the chart.

Deleting A Chart Element

You can delete any of the Excel charting elements in a chart. Heaven knows that you'll change your mind often enough.

To delete a chart element, follow these steps:

1. Select the chart element or data series to be deleted.
2. Press the DELETE key on the keyboard.

If you delete that last data series of the Excel charting elements, the chart will be empty.

Chart Basics

After your chart is done, you still can't relax. Now its time to do all those things that you should have done right earlier!

To activate a chart on a chart sheet, click the chart sheets tab.
To activate an embedded chart, click the chart itself.

Adding A New Data Series To A Chart

There are several ways of adding additional data series to your Excel charting elements.

Use one of the following methods to add new data series:

Select the range to be added and drag it into the chart.

When you release the mouse button, Excel updates the chart with the data you dragged into it.

This technique works only if the chart is embedded on the worksheet.
Activate the chart and choose Chart ► Add Data from the menu bar.

Excel displays a dialog box that prompts you for the range of data to add to the chart.
Select the range to be added and copy it to the Office Clipboard.

Then activate the chart and choose Edit ► Paste Special from the menu bar.

Excel responds with the Paste Special dialog box.

Complete this dialog box to correspond to the data that you selected.
Activate the chart and then choose Chart ► Source Data from the menu bar.

You'll get the 2nd Chart Wizard dialog box.

Edit the range reference to include the new data series (or point to the new range in the worksheet).

Click OK and Excel updates the chart with the new data.
See also...   Excel Charts  |  Excel Charting with the Chart Wizard
Dealing With Chart Elements | Change Data Series
Legend & Scale | Gridlines | Rotate & Elevate a 3D Chart
Back to Top
Return to Excel XP from Excel Charting Elements
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