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