Excel Charting Elements

Excel Charting Elements

Excel Charting Elements

Excel Charting Elements

# Excel Charting Elements | Microsoft Excel XP | Page 4

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

#### Working With Chart Legends

If you created your chart with the Chart Wizard, you had an option to include a legend as part of the Excel charting elements. If you change your mind, you can easily delete the legend or add one if you need one.

If you didn't include legend text when you originally selected the cells to create the chart, Excel displays Series 1, Series 2, and so on in the legend.

 1. Activate the chart. 2. Choose Chart ► Source Data from the menu bar. 3. In the Source Data dialog box, click the Series tab. 4. Select a series in the Series box and then enter a name in the Name box.For the name, you can use text or a reference to a cell that contains the series name. 5. Repeat Step 4 for each series that you want to name. 6. Click OK and the new names appear in the legend.

#### Changing A Charts Scale

In Excel charting elements, adjusting the scale of a value axis can have a dramatic effect on the appearance of the chart.  Excel always determines the scale for your charts automatically.

## You can, however, override the choice Excel makes:

 1. Activate the chart. 2. Select the value (Y) axis. 3. Choose Format ► Selected Axis from the menu bar. ORDouble-click the axis. 4. In the Format Axis dialog box, click the Scale tab. The dialog box varies slightly depending on which axis is selected.The Scale tab of the Format Axis dialog box offers the following options: ► MINIMUMLets you enter a minimum value for the axis. If checked, Excel determines this value automatically. ► MAXIMUMLets you enter a maximum value for the axis. If checked, Excel determines this value automatically. ► MAJOR UNIT Lets you enter the number of unit between major tick marks.If checked, Excel determines this value automatically.► MINOR UNITLets you enter the number of unit between minor tick marks.If checked, Excel determines this value automatically.► CATEGORY (X) AXIS CROSSES ATLets you position the axes at a different location. By default, the axes are positioned at the edge of the plot area. The exact wording of this option varies, depending on which axis you select. ► DISPLAY UNITSLets you set the display units for large numbers on the axis.Using this option can make numbers displayed on the axis shorter and more readable. ► SHOW DISPLAY UNITS LABEL ON CHARTLets you add a label on the axis that describes the units selected in the Display Units drop-down box. ► LOGARITHMIC SCALELets you use a logarithmic scale for the axes. Useful for scientific applications in which the values to be plotted have an extremely large range; a log scale gives you an error message if the scale includes 0 or negative values. ► VALUES IN REVERSE ORDERMakes the scale values extend in the opposite direction. ► CATEGORY (X) AXIS CROSSES AT MAXIMUM VALUELets you position the axes at the maximum value of the perpendicular axis (normally, the axis is positioned at the minimum value).The exact wording varies, depending on which axis you select. 5. Make the changes and then click OK.
###### Excel XP Topics
- Tips
- Excel Screen Layout
- 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
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Print
- Sorting
- AutoFilter