Stop charts from resizing when columns or rows change in Excel
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
How to set up your charts/ images and shapes in Excel so that the underlying cells do NOT affect the chart size. So when you change a column or row width, or insert or delete columns or rows, the chart does not change. It stays the same size as it originally was. If you have set up a dashboard and spent hours making sure all the charts are the same size and align correctly, this trick means that last minute fixes don't mess up your chart.
------------------------------------------------------------------------------------------------------------------------------------------------------
✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- https://online-excel-training.auditex...
🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/
------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Stop charts resizing (stretching or shrinking) when rows and columns are changed
00:15 Changing column widths changes chart sizes (they are no longer all the same size)
00:25 Tell Excel to NOT change chart/ image sizes if columns/ rows are changed/ inserted/ deleted
01:05 Change ALL the charts (at the same time) to lock the size of the chart