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 More
 

Scale the Chart

You can edit the height and width independently. Here is a method for keeping a fixed aspect ratio: changing both sides the same percent.

Try it: Scale the Chart

Select the chart.

Go to PivotTable Tools.

Look for Format->Size.

 

What Do You See? At the corner of the Size group you can see a small arrow. Click on the arrow to get to the advanced options.

 

 

Size and Scale: Adjust the Scale from 100% to 75%.

PivotChart Tools ->Format ->Size

 

 

  Microsoft Excel 2007 Exam 77-602 Topic: 4. Presenting Data Visually

  4.2. Modify charts   4.2.2.  Move and size charts: Size a chart while maintaining scale