How do I use a vertical look up to adjust a graph format?

J

jaypuhreps

I want to flip one chart on top of another based on a vertical look up
(ideally using an if/then statement).

E.g., if(a1 = "1", chart 1 on top, chart 2 on top)

or

If(a1= "1", run macro 1, run macro 2)

(marco 1 putting the first chart on top, versus macro 2 putting the second
chart on top)

Any advice on how to do this?
 
F

Fred Smith

You'd be better off to have one macro and pass it a1 as a parameter. Given a1,
the macro can decide which chart is on top, and which is on the bottom.
 
Top