Formatting Chart Elements

Before you can format a chart element, you need to select it first. You can select a chart element directly on the chart or use the Chart Elements list arrow on the Ribbon. After you select a chart element, you can use the Format Selection button to open the Format pane (New!), where you can change formatting options, including number, fill, border color and styles, shadow, 3-D format, and alignment. Formatting options vary depending on the selected chart element. In the same way you can apply shape fills, outlines, and effects to a shape, you can also apply them to elements and shapes in a chart.

Format a Chart Object

Select the chart element you want to modify.

Click the Format tab under Chart Tools.

Click the ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.