From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Pro tip: Prevent charts from resizing

Pro tip: Prevent charts from resizing - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Pro tip: Prevent charts from resizing

“

- [Instructor] In the last demo, when we dragged the genre field into the column labels in our third pivot, our worksheet automatically resized a bunch of columns, due to a default setting called autofit. So, what happened was that, all of these columns all the way out to R, got crunched down to the minimum width necessary to display the data in all of those genre columns. Which, in turn, shrunk the width of any charts that happened to be sitting on top of those columns. So, the good news is that there are at least two ways to avoid this issue, both of which are a little bit sneaky. So, this was something that bugged me for years before I finally figured it out. And lucky for you, I'm feeling pretty generous today, so I suppose I'll share my secrets. Now, solution one is to adjust the chart properties for any of the charts that are getting resized and this is a default setting in Excel. So when you drop in a new chart, like this column chart, for instance, you'll see that it's…

Contents