You could try grouping the charts (Select first chart, hold Ctrl while
clicking on 2nd chart, then right-click, group). Then, you can position the
entire object as desired, and it should anchor using the top-left corner
(which doesn't move very much).

Another idea is to double click on the 2nd chart, and Under Format Chart
Area, Properties, select "don't move or size with cells".

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Harold Good" wrote:

Hi,

I have two charts I have made to the right of a budget table. The top
chart is positioned near the top of the page, the second, a smaller
summary chart is just under the first one.

Problem is, the Budget table is an expandable outline that can expand by
dozens of rows. When in expanded mode, the second chart moves way down
off the visible page and is only viewable by scrolling, unless I
collapse the outline again.

The first chart is anchored at the top where little expansion takes
place, thus little movement.

Is there any way I can prevent this second chart from moving down when
budget is expanded?

Can I anchor the second chart to the bottom of the first one, or somehow
use VBA to offset 3 inches from the cell where the first one is anchored?

I'm not good with VBA, so any help with code would be greatly
appreciated, also with info where I put the code.

Thank you in advance for your creative ideas.
Harold