MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Align charts on worksheet using VBA


Posted by CPE on December 21, 2001 6:39 AM

I have a worksheet that has a chart on it. The chart starts at column A row 2.

When i hide or unhide columns or change their sizes the charts changes its position on the screen.

I want to always align the chart so that its top left hand corner is always positioned in column A row 2.

How can I trap the positioning of the chart on the screen in order to do this?

Thanks

Chris


Posted by Mike on December 27, 2001 7:21 AM

Try right clicking on the outside border of the chart. Then select FORMAT CHART AREA and then the PROPERTIES tab. Select the DON'T MOVE OR SIZE WITH CELLS option.

-Mike