You can instantly change the look of chart elements (such as the chart area, the plot area, data markers, titles in charts, gridlines, axes, tick marks, trendlines, error bars, or the walls and floor in 3-D charts) by applying a predefined shape style. You can also apply different shape fills, shape outlines, and shape effects to these chart elements.

  1. On a chart, click the chart element that you want to change, or do the following to select it from a list of chart elements:

    1. Click a chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs.

    2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want to use.

      excel ribbon image

  2. On the Format tab, in the Shape Styles group, click a predefined shape style or line style.

    To see all available shape styles, Click the More button More button.

Tip: If you don't like the change that you made, you can undo it immediately. On the Quick Access Toolbar, click Undo Undo button, or press CTRL+Z.

Quick access toolbar

You can fill a selected shape (such as data markers, titles, data labels, or a legend) with a solid color, gradient, picture, or texture. You cannot use shape fill to format lines in a chart (such as gridlines, axes, trendlines, or error bars).

  1. On a chart, click the chart element that you want to change, or do the following to select it from a list of chart elements:

    1. Click a chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs.

    2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want to use.

      excel ribbon image

  2. On the Format tab, in the Shape Styles group, click Shape Fill.

  3. Do one of the following:

    1. To use a different fill color, under Theme Colors or Standard Colors, click the color that you want to use.

      Tip: Before you apply a different color, you can quickly preview how that color affects the chart. When you point to colors that you may want to use, the selected chart element will be displayed in that color on the chart.

    2. To remove the color from the selected chart element, click No Fill.

    3. To use a fill color that is not available under Theme Colors or Standard Colors, click More Fill Colors. In the Colors dialog box, specify the color that you want to use on the Standard or Custom tab, and then click OK.

      Custom fill colors that you create are added under Recent Colors so that you can use them again.

    4. To fill the shape with a picture, click Picture. In the Insert Picture dialog box, click the picture that you want to use, and then click Insert.

    5. To use a gradient effect for the selected fill color, click Gradient, and then under Variations, click the gradient style that you want to use.

      For additional gradient styles, click More Gradients, and then in the Fill category, click the gradient options that you want to use.

    6. To use a texture fill, click Texture, and then click the texture that you want to use.

Tip: If you don't like the change that you made, you can undo it immediately. On the Quick Access Toolbar, click Undo Undo button, or press CTRL+Z.

Quick access toolbar

You can change the color, width, and line style of lines in a chart (such as gridlines, axes, trendlines, or error bars), or you can create custom borders for selected shapes (such as data markers, titles, data labels, or a legend).

  1. On a chart, click the chart element that you want to change, or do the following to select it from a list of chart elements:

    1. Click a chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs.

    2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want to use.

      excel ribbon image

  2. On the Format tab, in the Shape Styles group, click Shape Outline.

  3. Do one of the following:

    1. To use a different outline color, under Theme Colors or Standard Colors, click the color that you want to use.

    2. To remove the outline color from the selected chart element, click No Outline.

      Note: If the selected element is a line, the line will no longer be visible on the chart.

    3. To use an outline color that is not available under Theme Colors or Standard Colors, click More Outline Colors. In the Colors dialog box, specify the color that you want to use on the Standard or Custom tab, and then click OK.

      Custom outline colors that you create are added under Recent Colors so that you can use them again.

    4. To change the weight of a line or border, click Weight, and then click the line weight that you want to use.

      For additional line style or border style options, click More Lines, and then click the line style or border style options that you want to use.

    5. To use a dashed line or border, click Dashes, and then click the dash type that you want to use.

      For additional dash-type options, click More Lines, and then click the dash type that you want to use.

    6. To add arrows to lines, click Arrows, and then click the arrow style that you want to use. You cannot use arrow styles for borders.

      For additional arrow style or border style options, click More Arrows, and then click the arrow setting that you want to use.

Tip: If you don't like the change that you made, you can undo it immediately. On the Quick Access Toolbar, click Undo Undo button, or press CTRL+Z.

Quick access toolbar

You can apply visual effects (such as a shadow, glow, or bevel effects) to selected shapes (such as data markers, titles, data labels, or a legend) and lines (such as gridlines, axes, trendlines, or error bars).

  1. On a chart, click the chart element that you want to change, or do the following to select it from a list of chart elements:

    1. Click a chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs.

    2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want to use.

      excel ribbon image

  2. On the Format tab, in the Shape Styles group, click Shape Effects.

  3. Click an available effect, and then select the type of effect that you want to use.

    Note: Available shape effects depend on the chart element that you selected. Preset, reflection, and bevel effects are not available for all chart elements.

Tip: If you don't like the change that you made, you can undo it immediately. On the Quick Access Toolbar, click Undo Undo button, or press CTRL+Z.

Quick access toolbar

  1. Click a chart.

  2. On the Format tab, in the chart elements dropdown, select the chart element that you want to use.

  3. On the Format tab, in the shape styles gallery, click the arrow to expand and select a shape.

You can fill a selected shape (such as data markers, titles, data labels, or a legend) with a solid color, gradient, picture, or texture. You cannot use shape fill to format lines in a chart (such as gridlines, axes, trendlines, or error bars).

  1. Click a chart.

  2. On the Format tab, in the chart elements dropdown, select the chart element that you want to use.

  3. On the Format tab, click Shape Fill icon.

  4. Do one of the following:

    1. To use a different fill color, under Theme Colors or Standard Colors, click the color that you want to use.

    2. To remove the color from the selected chart element, click No Fill.

    3. To use a fill color that is not available under Theme Colors or Standard Colors, click More Fill Colors. In the Colors dialog box, use the available options to pick a color, and then click OK.

    4. To fill the shape with a picture, click Picture. In the Insert Picture dialog box, click the picture that you want to use, and then click Insert.

    5. To use a gradient effect for the selected fill color, click Gradient, and then click the gradient style that you want to use.

      For additional gradient styles, click More Gradients, and then in the Format Chart Area pane, under Fill, click the gradient options that you want to use.

    6. To use a texture fill, click Texture, and then click the texture that you want to use.

You can change the color, width, and line style of lines in a chart (such as gridlines, axes, trendlines, or error bars), or you can create custom borders for selected shapes (such as data markers, titles, data labels, or a legend).

  1. Click a chart.

  2. On the Format tab, in the chart elements dropdown, select the chart element that you want to use.

  3. On the Format tab, click (Shape Outline icon).

  4. Do one of the following:

    1. To use a different outline color, under Theme Colors or Standard Colors, click the color that you want to use.

    2. To remove the outline color from the selected chart element, click No Outline.

      Note: If the selected element is a line, the line will no longer be visible on the chart.

    3. To use an outline color that is not available under Theme Colors or Standard Colors, click More Outline Colors. In the Colors dialog box, use the available options to pick a color, and then click OK.

    4. To change the weight of a line or border, click Weight, and then click the line weight that you want to use.

    5. To use a dashed line or border, click Dashes, and then click the dash type that you want to use.

    6. To add arrows to lines, click Arrows, and then click the arrow style that you want to use. You cannot use arrow styles for borders.

You can apply visual effects (such as a shadow, glow, or bevel effects) to selected shapes (such as data markers, titles, data labels, or a legend) and lines (such as gridlines, axes, trendlines, or error bars).

  1. Click a chart.

  2. On the Format tab, in the chart elements dropdown, select the chart element that you want to use.

  3. On the Format tab, click Shape Effects icon(Shape Effects icon).

  4. Click an available effect, and then select the type of effect that you want to use.

    Note: Available shape effects depend on the chart element that you selected. Preset, reflection, and bevel effects are not available for all chart elements.

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.