Use excel to edit chart: Selecting and editing individual chart elements

Use excel to edit chart: YOUR OBJECTIVE

You generated a chart to graphically depict your company’s sales data, but now, to better suit your needs, you want to alter some of the chart’s elements, such as the number format used on the vertical axis and possibly the chart’s background.

In this learning module “ Excel: Edit chart“, you will be shown how to edit various chart elements and some thing to consider when doing so.

 

 

Use excel to edit chart: HOW DOES IT WORK?

Use excel to edit chart or reformat any chart element – anytime, even long after the chart was generated. To edit or reformat a chart’s elements, you must first select the chart by clicking somewhere on it. When you do, the Chart Tools context tab along with its subordinated Design, Layout and Format tabs will appear on the Ribbon. Then go to the Layout tab. There, you will find various groups of commands that allow you to make changes to the chart:

 

In the Current Selection group, click the arrow button  : 

 

A list of all elements that can be changed in the currently selected chart will appear: 

 

To change the number format for the vertical axis, for example, click Vertical (Value) Axis in the selection list. As you can see in the chart, the vertical value axis is now selected:

 

To format the vertical axis, click the button in the Current Selection group. 

 

The Format Axis dialog box will appear: 

 

Axis Options: Here you can specify the interval and scale used on the axis.

Number: Here you can define the number format.

Fill: Here you can select a fill color and effects.

Line Color: Here you can determine line colors for the element.

Line Style: If you chose to display a line, you can select a style for it here.

Shadow: If you defined a line or frame around the element, you can specify a shadow effect for it here.

Glow and Soft Edges: If you defined a line or frame around the element, you can specify glow efffects for it here. You can also decide to display such lines with soft edges.

3-D Format: If you defined a frame around the element, you will find 3-D Format templates here.

Alignment: Here you can change the element’s text alignment.

If you want to change the Number format for the axis, select the desired format from the Category list and set additional parameters, as needed:

 

To apply all your settings and close the dialog box, click Close.

The numbers on the value axis will then display with your chosen format and settings – in our example, the Accounting format without any Decimal places after the decimal point (as shown): 

 

HINT

Instead of using the selection list in the Current Selection group to select a chart element, you can also select it just by clicking directly on it. A right-click on the selected element will produce a selection list in which a Format command appears. If clicked, the same Format dialog box as described above will appear.

 

Did you like it? Then share it or sign up!

You can share this article with your friends or sign up for our newsletter for further information.

Leave a comment

Connect with Facebook

*

Kein Banner zum Anzeigen