Forum Discussion
Swapping x-y axes in scatter plots with 20 series
Dear Community, I want to swap the x and y axes for dozens of scatter plots each with about 20 series. A simple default rendition looks like this with the y values in the table displayed horizontal...
I assume you are having problems getting images to display? The snipping tool and linking to capture.jpg is one way.
I think it is fairly normal for scatter charts to have multiple series that share a common x-axis. That is lost if you transpose the axes but you should still be able to edit the series, inserting new series based upon their individual x- and y-series.