Formatting Chart Elements

You can use the Format dialog to apply a variety of formatting to chart elements:

  • Font enables you to change the appearance of an element's font characters.

  • Number enables you to change the number formatting of values.

  • Alignment enables you to change the alignment and orientation of text.

  • Patterns enables you to change an element's color and pattern. It also enables you to set styles for axis tick marks—the tiny lines that mark values and labels on a chart's axes.

  • Placement enables you to set the position for a chart legend.

  • Scale enables you to change the values that appear on an axis.

  • Shape enables you to change the shape of data points.

  • Data Labels enables you to set data labels for a single data series or data point. I ...

Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide 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.