Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

You can change the format of individual chart elements, such as the chart area, plot area, data series, axes, titles, data labels, or legend.

Two sets of tools are available for formatting chart elements: the Format task pane and the Chart Tools Ribbon. For the most control, use the options in the Format task pane.

Format your chart using the Format task pane

Select the chart element (for example, data series, axes, or titles), right-click it, and click Format <chart element>. The Format pane appears with options that are tailored for the selected chart element.

Format Axis task pane

Clicking the small icons at the top of the pane moves you to other parts of the pane with more options. If you click on a different chart element, you’ll see that the task pane automatically updates to the new chart element.

For example, to format an axis:

  1. Right-click the chart axis, and click Format Axis.

    Format Axis right-click menu

  2. In the Format Axis task pane, make the changes you want.

    You can move or resize the task pane to make working with it easier. Click the chevron in the upper right.

    Top part of the Format Axis pane with the chevron highlighted

    • Select Move and then drag the pane to a new location.

    • Select Size and drag the edge of the pane to resize it.

Format your chart using the Ribbon

  1. In your chart, click to select the chart element that you want to format.

  2. On the Format tab under Chart Tools, do one of the following:

    • Click Shape Fill to apply a different fill color, or a gradient, picture, or texture to the chart element.

      The Shape Fill button

    • Click Shape Outline to change the color, weight, or style of the chart element.

      The Shape Outline button

    • Click Shape Effects to apply special visual effects to the chart element, such as shadows, bevels, or 3-D rotation.

      The Shape Effects button

    • To apply a predefined shape style, on the Format tab, in the Shape Styles group, click the style that you want. To see all available shape styles, click the More button .

      The Shape Styles group

    • To change the format of chart text, select the text, and then choose an option on the mini toolbar that appears. Or, on the Home tab, in the Font group, select the formatting that you want to use.

    • To use WordArt styles to format text, select the text, and then on the Format tab in the WordArt Styles group, choose a WordArt style to apply. To see all available styles, click the More button .

      The WordArt Styles group

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×