Solved

Chart & Hidden columns

Posted on 2012-12-21
1
390 Views
Last Modified: 2012-12-21
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
0
Comment
Question by:APD_Toronto
1 Comment
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 38713672
Select the chart
Right-click and select format chart area
Select the properties tab
Select don't move or resize with cells
Ok
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question