ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Chart resizes with changes to hidden cells (https://www.excelbanter.com/excel-discussion-misc-queries/152893-chart-resizes-changes-hidden-cells.html)

Pflugs

Chart resizes with changes to hidden cells
 
Could someone remind me how to disable the "resize with cells" feature for
embedded charts? Every time I unhide rows, my charts go crazy. I can't
remember how to do it.

Thanks,
Pflugs

bj

Chart resizes with changes to hidden cells
 
right click on the chart and select format chart area
select properties and select either move but dont size with cells or don't
move or resize with cells depending on what you want.


"Pflugs" wrote:

Could someone remind me how to disable the "resize with cells" feature for
embedded charts? Every time I unhide rows, my charts go crazy. I can't
remember how to do it.

Thanks,
Pflugs


Pflugs

Chart resizes with changes to hidden cells
 
Good grief, there it is! Thanks!
Pflugs

"bj" wrote:

right click on the chart and select format chart area
select properties and select either move but dont size with cells or don't
move or resize with cells depending on what you want.


"Pflugs" wrote:

Could someone remind me how to disable the "resize with cells" feature for
embedded charts? Every time I unhide rows, my charts go crazy. I can't
remember how to do it.

Thanks,
Pflugs



All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com