SOLVED

PIVOT Diagram help!

%3CLINGO-SUB%20id%3D%22lingo-sub-1511204%22%20slang%3D%22de-DE%22%3EPIVOT%20Diagram%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1511204%22%20slang%3D%22de-DE%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EHello%20dear%20community%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20made%20a%20diagram%20with%20Pivot%20which%20looks%20good%20but%20the%20date%20tab%20should%20be%20sorted%20as%20a%20whole%20and%20not%20sorted%20separately%20for%20every%20order!%3C%2FSPAN%3E%20%3CSPAN%3EI%20know%20if%20I%20have%20exchanged%20date%20and%20order%20it%20is%20sorted%20but%20unfortunately%20very%20confusing!%3C%2FSPAN%3E%3CBR%20%2F%3E%20%3CSPAN%3EI%20would%20like%20to%20have%20it%20as%20in%20the%20picture%20but%20that%20is%20the%20date%20where%20it%20should%20and%20then%20the%20order%20has%20to%20be%20placed%202%20or%203%20times.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22help.PNG%22%20style%3D%22width%3A%20883px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204314i626794B9DAE77115%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22help.PNG%22%20alt%3D%22Help.%20Png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Ethanks%20in%20advance%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1511204%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1511401%22%20slang%3D%22en-US%22%3ERe%3A%20PIVOT%20Diagram%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1511401%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F709965%22%20target%3D%22_blank%22%3E%40Felix285%3C%2FA%3E%26nbsp%3BI%20suspect%20that%20you%20have%20Order%20first%20and%20then%20Date%20as%20the%20row%20labels%20in%20the%20pivot%20table.%20Switch%20them%20around.%20Date%20first%2C%20then%20Order.%20That%20should%20swap%20the%20X-axis%20on%20the%20Pivot%20Chart%20as%20well.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-07-09%20at%2012.56.00.png%22%20style%3D%22width%3A%20162px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204324i74602ACBCF24F40F%2Fimage-dimensions%2F162x136%3Fv%3D1.0%22%20width%3D%22162%22%20height%3D%22136%22%20title%3D%22Screenshot%202020-07-09%20at%2012.56.00.png%22%20alt%3D%22Screenshot%202020-07-09%20at%2012.56.00.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1513694%22%20slang%3D%22de-DE%22%3ERe%3A%20PIVOT%20Diagram%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1513694%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EI%20have%20already%20tried%20this%20but%20then%20the%20diagram%20is%20very%20confusing%20because%20it%20shows%206%20times%20up%20and%20down%20orders%20and%20the%20date%20completely%20overlaps%20so%20that%20you%20have%20a%20very%20confusing%20diagram.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Unbenannt.PNG%22%20style%3D%22width%3A%20168px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204544i1DBD558B83C2E5BD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Unbenannt.PNG%22%20alt%3D%22Unnamed.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EThank%20you%20for%20your%20answer%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1514081%22%20slang%3D%22en-US%22%3ERe%3A%20PIVOT%20Diagram%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1514081%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F709965%22%20target%3D%22_blank%22%3E%40Felix285%3C%2FA%3E%26nbsp%3Bcan%20you%20share%20a%20sample%20of%20your%20data%2C%20without%20revealing%20any%20confidential%20information.%20so%20much%20easier%20to%20work%20with%20some%20data%20than%20looking%20at%20a%20picture.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518122%22%20slang%3D%22de-DE%22%3ERe%3A%20PIVOT%20Diagram%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518122%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%20%3CSPAN%3E%20here%20is%20the%20test%20file%2C%20I%20hope%20you%20know%20what%20I%20mean.%26nbsp%3B%20And%20thank%20you%20for%20your%20commitment!%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22oSioSc%22%3E%3CDIV%3E%3CDIV%20class%3D%22Vyy3r%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22g9WsWb%22%3E%3CDIV%20class%3D%22tw-ta-container%20hide-focus-ring%20tw-nfl%22%3E%3CDIV%20class%3D%22oSioSc%22%3E%3CDIV%3E%3CDIV%20class%3D%22Vyy3r%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22g9WsWb%22%3E%3CDIV%20class%3D%22tw-ta-container%20hide-focus-ring%20tw-nfl%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518305%22%20slang%3D%22en-US%22%3ERe%3A%20PIVOT%20Diagram%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518305%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F709965%22%20target%3D%22_blank%22%3E%40Felix285%3C%2FA%3E%26nbsp%3BPerhaps%20the%20attached%20file%20holds%20an%20acceptable%20solution%20(see%20Sheet1).%20I%20added%20a%20column%20for%20a%20text%20representation%20of%20the%20date%20(DateTxt)%2C%20wrapping%20the%20%22too%20long%22%20date%20onto%20three%20lines.%26nbsp%3BThen%20sorted%20the%20data%20table%20by%20date%20and%20created%20the%20PivotChart%20via%20PowerPivot%2C%20using%20the%20DateTxt%20field.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-07-13%20at%2010.51.24.png%22%20style%3D%22width%3A%20351px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204997i575F7CDA939005D6%2Fimage-dimensions%2F351x316%3Fv%3D1.0%22%20width%3D%22351%22%20height%3D%22316%22%20title%3D%22Screenshot%202020-07-13%20at%2010.51.24.png%22%20alt%3D%22Screenshot%202020-07-13%20at%2010.51.24.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor
Hello dear community,
I made a diagram with Pivot which looks good but the Date tab should be sorted as a whole and not sorted separately for every order! I know if I have exchanged date and order it is sorted but unfortunately very confusing!
I would like to have it as in the picture but that is the date where it should and then the order has to be placed 2 or 3 times.
help.PNG
thanks in advance
5 Replies

@Felix285 I suspect that you have Order first and then Date as the row labels in the pivot table. Switch them around. Date first, then Order. That should swap the X-axis on the Pivot Chart as well.

Screenshot 2020-07-09 at 12.56.00.png

 

@Riny_van_Eekelen 

I have already tried this but then the diagram is very confusing because it shows 6 times up and down orders and the date completely overlaps so that you have a very confusing diagram.
Unbenannt.PNG
Thank you for your answer

@Felix285 can you share a sample of your data, without revealing any confidential information. so much easier to work with some data than looking at a picture.

@Riny_van_Eekelen here is the test file, I hope you know what I mean. And thank you for your commitment!

 
 
 
Best Response confirmed by Felix285 (Occasional Contributor)
Solution

@Felix285 Perhaps the attached file holds an acceptable solution (see Sheet1). I added a column for a text representation of the date (DateTxt), wrapping the "too long" date onto three lines. Then sorted the data table by date and created the PivotChart via PowerPivot, using the DateTxt field.

 

Screenshot 2020-07-13 at 10.51.24.png