Scales of embedded graphs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to create a macro of some sort to go into every graph in a
presentation and change the min/max values?
I tried recording a macro, but as you may be aware, it fails as soon as I
enter the embedded graph.

Note: I could do this manually but since there are well over 200 graphs...
 
Is it possible to create a macro of some sort to go into every graph in a
presentation and change the min/max values?
I tried recording a macro, but as you may be aware, it fails as soon as I
enter the embedded graph.
Click to expand...

It's possible but not all that simple. Have a look here:

Working with MSGraph charts
http://www.pptfaq.com/index.html#name_Working_with_MSGraph_charts

If it makes your head spin, sit down and put your head between your knees until
the nausea passes. ;-)

One very useful trick: create a similar chart in Excel and record a macro
there as you change the min/max. That will generally give you code that you
can apply in your macros that manipulate MSGraph.
 
Back
Top