Breathtaking Excel Chart Plot Area Size
Of course similarly you can increase the chart area first and reduce the plot area thereafter to increase the chart area relative to plot area as you.
Excel chart plot area size. By default you cannot resize the chart by dragging the edges you have to change the page borders in page setup. Adjust your column width and row height to the required size. When you remove an axis x or y the size of the plot area changes.
You can click to select a plot area or right-click and use the mini toolbar to select. Resize chart area in Excel 1. To scale the Plot Area click within it then use the Sizing Handles at the 4 corners the midpoint of each side.
You can change this positioning option if you dont want to move or resize the chart together with the worksheet cells. I have a bar chart in a spreadsheet and want to precisely control the plot area such that when the chart is printed the grids are exactly 10mm squares. Handles will appear on the sides of the plot area.
Click the chart and click Layout tab or Format tab. If you cant read the titles or labels this tip will help cleanup. Once you change the size of Chart Plot Area excel automatically disables plot area auto size.
I tried to fix the position and size for the plot area using vba but this simply does not work unfortunately. - change the Y-axis scaling to not be auto - this is. Select Snap to Grid from Page Layout Arrange Align.
I think you need to mke the plot area larger. This will let you set your dimensions in real units eg. Excel MVP Jon Peltier suggests to reset the charts formatting Chart menu Chart Type check the Default Formatting checkbox.