Learn step-by-step how to modify all the Excel charting elements of a
Excel Charting Elements | Microsoft Excel XP | Page 2
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:
the chart element you want to move.
||Click the border of the element and drag it to the
desired location in the chart.
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:
the chart element or data series to be deleted.
||Press the DELETE key on the keyboard.
If you delete that last data series of the Excel charting elements, the chart will be
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
||To activate an embedded chart, click the chart itself.
There are several ways of adding additional data series to your Excel charting
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
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
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.
Excel XP Topics
- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- 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
- Text Direction
- Indent Contents
- Merge Cells
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- Advanced Filter
- Charting Elements
- Gantt Chart
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter