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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!