none
Need a VB Macro that will move all series plots on active chart to the secondary axis. RRS feed

  • Question

  • Hello,

    I really need a VB Macro that will move all series plots on the active chart to the secondary axis. My test data charts have many time series plots. Usually 50+/- on one chart. All but a few need to be on the secondary axis though. So, presently I'm clicking to move the plots to the secondary axis one buy one. This takes a ridiculous amount of time. I was thinking if I could move all the plots to the secondary axis with a macro, then move the two or three plots needed back to the primary axis, it would same me hours of time clicking. Can this be done? Move all line plots on the active chart to the secondary axis, regardless of whether it is 3 plots or 333 plots? The chart can be on its own tab if need be (if that makes it simpler).

    Thanks in advance,

    atherton00

    Thursday, March 22, 2018 9:39 PM