ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Retaining Embedded Chart size when columns under it are hidden/add (https://www.excelbanter.com/charts-charting-excel/126478-retaining-embedded-chart-size-when-columns-under-hidden-add.html)

Barb Reinhardt

Retaining Embedded Chart size when columns under it are hidden/add
 
What is the setting I need to use for object positioning:

Move and size with cells - NOPE
Move but don't size with cells
Don't move or size with cells

I want the chart to remain on the page in the same apparently location if
columns underneath it are added or hidden.

Thanks

Jon Peltier

Retaining Embedded Chart size when columns under it are hidden/add
 
Don't move or size with cells - the chart stays the same size and the same
distance from the top and left edges of the worksheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Barb Reinhardt" wrote in message
...
What is the setting I need to use for object positioning:

Move and size with cells - NOPE
Move but don't size with cells
Don't move or size with cells

I want the chart to remain on the page in the same apparently location if
columns underneath it are added or hidden.

Thanks





All times are GMT +1. The time now is 06:44 PM.

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