Change colors, patterns, lines, fills, and borders in charts

Use this procedure to change colors, apply a texture or pattern, or change the line width or border style for data markers, the chart area, the plot area, gridlines, axes, and tick marks in 2-D and 3-D charts, trendlines and error bars in 2-D charts, and the walls and floor in 3-D charts.

  1. Double-click the chart item you want to change.

  2. If necessary, click the Patterns tab, and then select the options you want.

  3. Under Border, select Automatic, None, or Custom. If you select Custom, you can choose additional options for the border Style, Color, and Weight.

  4. Under Area, select Automatic or None and then choose a color from a color palette.

  5. To specify a fill effect, click Fill Effects, and then select the options you want on the Gradient, Texture, or Pattern tabs.

    The Preview box displays a preview of the pattern options you selected.

  6. Click OK to save your changes.

Note: Formatting applied to an axis is also applied to the tick marks on that axis. Gridlines are formatted independently of axes.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.