Amazing Excel Resize Chart Area Without Resizing Plot Area

How do I specify the exact size.

Excel resize chart area without resizing plot area. To resize a chart just use any one of the eight handles visible when the chart is selected. I made a function that finds the dimensions of a rectangle that. When using the corner handles you can lock the aspect ratio of the chart by holding down the Shift key as you drag.

To be able to resize a chart you must first select it you do that by left-click on the chart with the mouse. Learn how to resize the plot area so prevent the axis titles and labels from overlapping. - change the Y-axis scaling to not be auto - this is no good because the data could vary a lot.

I have fixed my charts to move and resize with the cells plus removed font autoscaling -- these are working fine so that the main larger area of the graphs are all fixed. Then just click and drag to a new location. I need to make the X Y axis the same scale ie.

You need to see a the charts plot area. In many Excel charts you can also resize the plot area directly. To move a chart manually hover your mouse over the chart area until you see a 4-headed arrow.

Note the size of the plot area may change as you add elements to a chart. The corner dots behave differently they change two sides of the chart simultaneously. You can resize every part of the chart with the above steps.

When you change the size of cells on the worksheet the size of the chart adjusts accordingly. How to Resize Excel Plot Area Hi I have a Bubble Chart where I am plotting a value Z against XY co-ordinates. But another page setup trick is on the chart tab off the dialog select the Custom size option.