Excel: What Happened? Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Pivot Chart Options

Look on the PivotTable Tools to find the Design tab. Go ahead, try various Chart Layouts and Chart Styles.

Try it: Edit the Chart Layout

Go to PivotTable Tools.

Look for Design->Chart Layout.

 

Here is a design consideration: what is the purpose of this chart? What story are you trying to convey in a quick, effective visualization?

 

Keep the formatting simple and easy to read.

PivotTable Tools ->Design ->Chart Layout