Stop charts stretching when the column width changes

Please sign up for the course before starting the lesson.

once you have set up several charts (perhaps you have created a dashboard), you may realise that you need to increase/ decrease certain column widths. The problem with this is that any Charts touching that column will, by default, stretch or compress and could mess with your look and feel.

So below we need to double click the A column so that the heading sits in its own cell.

Stop charts stretching when the column changes

The problem is that the charts will then look like this (the change in column width has stretched division 1 and 3’s charts.

Stop charts stretching when the column changes

To see the full course contents click here.

Back to: Advanced Excel Course > Charting In Excel