software

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 = quot;1quot;, chart 1 on top, chart 2 on top)

or

If(a1= quot;1quot;, 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?

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.

--
Regards,
Fredquot;jaypuhrepsquot; gt; wrote in message
...
gt;I want to flip one chart on top of another based on a vertical look up
gt; (ideally using an if/then statement).
gt;
gt; E.g., if(a1 = quot;1quot;, chart 1 on top, chart 2 on top)
gt;
gt; or
gt;
gt; If(a1= quot;1quot;, run macro 1, run macro 2)
gt;
gt; (marco 1 putting the first chart on top, versus macro 2 putting the second
gt; chart on top)
gt;
gt; Any advice on how to do this?