How to lock vertical positon of linked excel charts

I link charts from excel into powerpoint. The total number of rows will
periodically decrease/increase. The original linked chart is the max size.
It can only decrease from there and maybe increase back to the original size
as the data changes. All of my charts have a vertical position of 1.5 so
they don't "jump" around to the viewer. How can I lock the vertical position
when the data changes so I don't have to manually reset the slides? My
automated slide deck is approx 124 slides, approx 50% are linked charts.
Manually checking and fixing is not a good option.

Thanks.

For example, I have a chart that lists programs. I have vba in excel that
looks at each row in the chart and if there isn't any amounts, it hides the
row. In other words, the users don't want to see the rows if there isn't any
data. They only want to see rows having amounts.

The initial linked chart includes all programs so I don't have to chase the
chart when a program has data. In other words, I want the chart to
automatically capture all possible programs.

All of my charts have a vertical position in Powerpoint of 1.5 so they don't
"jump" around to the viewer.

When the rows hide/unhide, the vertical position of the slide changes. Not
good. How can I lock the vertical position of the chart when the rows
hide/unhide so I don't have to manually reset the slides? My automated
slide deck is approx 124 slides, approx 50% are linked charts. Manually
checking and fixing is not a good option.

E.M. PowerPoint Video Converter is an all-in-one PowerPoint to video
converter. It can convert PowerPoint presentations to almost all
popular video formats such as AVI, MPEG, MPEG2 TS, MP4, WMV, 3GP, GIF,
FLV, SWF, H.264/MPEG-4 AVC, H.264/PSP AVC Video, MOV, Youtube FLV with
excellent quality. you could easily convert PowerPoint presentations
to play on your iPod, PSP, Zune, 3GP mobile phone(Nokia, Sony
Ericsson, Motorola), Apple TV, iPhone etc. With E.M. PowerPoint Video
Converter "converting + burning" one-step solution, you could easily
convert and burn PowerPoint to DVD, VCD, SVCD, Audio CD.
http://www.effectmatrix.com/PowerPoi...rter/index.htm
http://www.google.com/search?hl=en&q...=f&oq=&aqi=g10

In article , Russ wrote:
Here's the macro I attempted to record.

See my answer elsewhere.