Home

Swapping x-y axes in scatter plots with 20 series

%3CLINGO-SUB%20id%3D%22lingo-sub-423577%22%20slang%3D%22en-US%22%3ESwapping%20x-y%20axes%20in%20scatter%20plots%20with%2020%20series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-423577%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Community%2C%3C%2FP%3E%3CP%3EI%20want%20to%20swap%20the%20x%20and%20y%20axes%20for%20dozens%20of%20scatter%20plots%20each%20with%20about%2020%20series.%20%26nbsp%3BA%20simple%20default%20rendition%20looks%20like%20this%20with%20the%20y%20values%20in%20the%20table%20displayed%20horizontally%20in%20the%20chart%20(FIGURE%201)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20default%20chart%20example%20appears%20here%20(y%20values%200-2000%20displayed%20horizontally)%20(FIGURE%202)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20want%20is%20something%20like%20this%20(y%20values%200-2000%20displayed%20vertically)(Figure%203)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20open%20the%20dialog%20box%20of%20the%20plot%20and%20edit%20the%20series%2C%20so%20that%20the%20x%20becomes%20y%20and%20y%20becomes%20x%2C%20(1)%20it%20is%20laborious%20for%20several%20series%2C%20(2)%20the%20box%20says%20%E2%80%9CThe%20data%20range%20is%20too%20complex%20to%20be%20displayed.%26nbsp%3B%20If%20a%20new%20series%20is%20selected%2C%20it%20will%20replace%20all%20the%20series%20in%20the%20series%20panel.%E2%80%9D%2C%20and%20(3)%20the%20blue%20and%20purple%20highlight%20boxes%20in%20the%20corresponding%20table%20are%20swapped%20to%20new%20positions%2C%20which%20makes%20sense%2C%20but%20disallows%20the%20user%20from%20adding%20new%20series%20by%20dragging%20the%20corner%20handle%20to%20include%20the%20new%20series%20columns%20because%20only%20the%20last%20series%20in%20the%20stretched%20purple%20box%20is%20included%20in%20the%20plot%2C%20thereby%20forcing%20the%20user%20to%20add%20additional%20series%20one%20by%20one%20with%20the%20dialog%20box.%26nbsp%3B%20Pictures%20of%20(2)%20(FIGURE%204)and%20(3)%20(FIGURE%205)%20appear%20below.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20excel%20the%20best%20for%20this%2C%20or%20is%20there%20some%20other%20graphing%20program%3F%26nbsp%3B%20I%20have%20tried%202010%2C%202013%2C%202016%2C%20and%20Excel%20Online%2C%20and%20as%20far%20as%20I%20can%20tell%2C%20all%20have%20this%20shortcoming.%26nbsp%3B%20How%20serious%20is%20(2)%3F%26nbsp%3B%20With%20a%20data%20points%20and%20one%20series%2C%20I%20can%20confirm%20whether%20the%20chart%20accurately%20represents%20the%20table%2C%20but%20with%20many%20series%20and%20rows%20of%20data%2C%20it%20becomes%20impossible.%26nbsp%3B%20Clearly%20the%20chart%20is%20compromised%20because%20the%20user%20can%20no%20long%20click%20on%20the%20chart%20to%20reveal%20the%20purple%20and%20blue%20highlight%20boxes%20in%20the%20table%3B%20the%20user%20must%20select%20one%20series%20in%20the%20chart%20to%20reveal%20the%20highlight%20boxes%20for%20that%20series%20only.%20Regarding%20(3)%2C%20how%20can%20I%20swap%20all%20the%20axes%20at%20once%2C%20instead%20of%20one%20by%20one%2C%20and%20how%20can%20I%20add%20more%20series%20by%20dragging%20the%20highlight%20boxes%2C%20instead%20of%20adding%20each%20series%20one%20by%20one%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3ERalph%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-423577%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-423657%22%20slang%3D%22en-US%22%3ERe%3A%20Swapping%20x-y%20axes%20in%20scatter%20plots%20with%2020%20series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-423657%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F157453%22%20target%3D%22_blank%22%3E%40Ralph%20Puchalski%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-425757%22%20slang%3D%22en-US%22%3ERe%3A%20Swapping%20x-y%20axes%20in%20scatter%20plots%20with%2020%20series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-425757%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F157453%22%20target%3D%22_blank%22%3E%40Ralph%20Puchalski%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20assume%3C%2FSPAN%3E%20you%20are%20having%20problems%20getting%20images%20to%20display%3F%26nbsp%3B%20The%20snipping%20tool%20and%20linking%20to%20capture.jpg%20is%20one%20way.%3C%2FP%3E%3CP%3EI%20think%20it%20is%20fairly%20normal%20for%20scatter%20charts%20to%20have%20multiple%20series%20that%20share%20a%20common%20x-axis.%26nbsp%3B%20That%20is%20lost%20if%20you%20transpose%20the%20axes%20but%20you%20should%20still%20be%20able%20to%20edit%20the%20series%2C%20inserting%20new%20series%20based%20upon%20their%20individual%20x-%20and%20y-series.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Ralph Puchalski
Occasional Contributor

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 horizontally in the chart (FIGURE 1):

 

Another default chart example appears here (y values 0-2000 displayed horizontally) (FIGURE 2):

 

What I want is something like this (y values 0-2000 displayed vertically)(Figure 3):

 

If I open the dialog box of the plot and edit the series, so that the x becomes y and y becomes x, (1) it is laborious for several series, (2) the box says “The data range is too complex to be displayed.  If a new series is selected, it will replace all the series in the series panel.”, and (3) the blue and purple highlight boxes in the corresponding table are swapped to new positions, which makes sense, but disallows the user from adding new series by dragging the corner handle to include the new series columns because only the last series in the stretched purple box is included in the plot, thereby forcing the user to add additional series one by one with the dialog box.  Pictures of (2) (FIGURE 4)and (3) (FIGURE 5) appear below. 

 

Is excel the best for this, or is there some other graphing program?  I have tried 2010, 2013, 2016, and Excel Online, and as far as I can tell, all have this shortcoming.  How serious is (2)?  With a data points and one series, I can confirm whether the chart accurately represents the table, but with many series and rows of data, it becomes impossible.  Clearly the chart is compromised because the user can no long click on the chart to reveal the purple and blue highlight boxes in the table; the user must select one series in the chart to reveal the highlight boxes for that series only. Regarding (3), how can I swap all the axes at once, instead of one by one, and how can I add more series by dragging the highlight boxes, instead of adding each series one by one?

 

Thank you,

Ralph

 

2 Replies

@Ralph Puchalski 

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies