Add, remove, or change a legend in PivotChart view
- Open a datasheet or form in PivotChart view.
- Do one or more of the following:
-
Select the chart workspace by clicking the blank area outside the plot area but within the chart boundaries.
-
On the PivotChart toolbar, click Show Legend
.
-
Click the legend you want to change.
-
On the PivotChart toolbar, click Properties
. -
Do one of the following:
-
Click the Format tab.
-
Under Position, in the Position box, click Top, Bottom, Left, or Right.
Change the border weight or color and background color-
Click the Border/Fill tab.
-
Under Border, select the Color, Weight, or Dash options you want.
-
Under Fill, select the Fill Type and Color you want.
Change the font or size of text-
Click the Format tab.
-
Under Text format, select the options you want.
-