I have a scatter chart (though I don't believe that matters), and I have positive nonzero values that correspond to the X axis and Y axis.
So that I can view the chart a little differently, how do I switch the axes?
I have a number of charts so I'd prefer not to do it manually. Excel help only showed how to move the Y axis to the left or right side of the chart, or how to move the X axis to the top or bottom, but didn't indicate how to swap the two.
Thanks,
Mike
So that I can view the chart a little differently, how do I switch the axes?
I have a number of charts so I'd prefer not to do it manually. Excel help only showed how to move the Y axis to the left or right side of the chart, or how to move the X axis to the top or bottom, but didn't indicate how to swap the two.
Thanks,
Mike