How to lock vertical positon of linked excel charts

R

Russ

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.
 
R

Russ

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.
 
W

windhello

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/PowerPoint-Video-Converter/index.htm
http://www.google.com/search?hl=en&...Converter&btnG=Google+Search&aq=f&oq=&aqi=g10
 
R

Russ

Thanks. I tried recording a macro but I didn't have success. I would
appreciate any advice you could provide. Thanks.
 
R

Russ

Here's the macro I attempted to record.

Sub Macro1()

ActiveWindow.Selection.Unselect
With ActiveWindow.Selection.ShapeRange
.Fill.Transparency = 0#
.Top = 107.88
End With

End Sub

When I attempt to run it, I get the following Microsoft Visual Basic error.

Run-time error'-2147188160 (80048240)':
Selection (unknown member): Invalid request. Nothing appropriate is
currently selected.

The End and Debug buttons are visible.

If I click the debug button, the following statement is highlighted in
yellow: With ActiveWindow.Selection.ShapeRange

I hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top