Chart & Hidden columns

APD Toronto
APD Toronto used Ask the Experts™
on
Hi Experts,

If I haved a chart inserted in a sheet, and I hide some columns, my sheet gets cut off.  Is there any way to avoid this, using a property or VBA?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Select the chart
Right-click and select format chart area
Select the properties tab
Select don't move or resize with cells
Ok

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial