Jul 09 2020 02:06 AM
Jul 09 2020 03:58 AM
@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.
Jul 09 2020 11:11 PM
Jul 10 2020 03:32 AM
@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.
Jul 13 2020 12:17 AM
@Riny_van_Eekelen here is the test file, I hope you know what I mean. And thank you for your commitment!
Jul 13 2020 02:02 AM
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.
Jul 13 2020 02:02 AM
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.