Chart Columns Resolution For Free

The Solution:Right-click in the table, choose Table Properties, and click the Table tab if it's not already displayed.Click the Options button, uncheck the "Automatically resize to fit contents" box, and then click the OK button to close each dialog box (see Figure 7-2).

Lock Aspect Ratio is the possibility to preserve the relative width and height when you resize an image or graphics shape. When locked, the original proportions of the selected shape are preserved when the height or width is changed.

Prevent a chart from moving and sizing with cells on the worksheetClick anywhere in the chart.Click the Format tab, in the Size group, click the Dialog Box Launcher .In the Format Chart Area dialog box, click the Properties tab.Under Object Positioning select the appropriate option.

Prevent a chart from moving and sizing with cells on the worksheetClick anywhere in the chart.Click the Format tab, in the Size group, click the Dialog Box Launcher .In the Format Chart Area dialog box, click the Properties tab.Under Object Positioning select the appropriate option.

When using the corner handles, you can lock the aspect ratio of the chart by holding down the Shift key as you drag. You can also enter height and width measurements directly in the Size group of the Format tab. For example, we can enter a height of 4" and a width of 6".

Select and right click the cells you need to unlock, then click Format Cells from the right-clicking menu. In the Format Cells dialog box, uncheck the Locked box on the Protection tab, then click the OK button.

The solution for this is to click the Excel chart's X axis, right click and choose Format Axis. Select Axis Options and then click on Text Axis to select it. This changes the way the axis is plotted giving wider bars. You can then adjust the gap width if necessary to make them wider.