Hello,
I like the Dot Plot style from the great article Line Charts vs Dot Plot: https://www.myonlinetraininghub.com/excel-line-charts-vs-dot-plot
How can I rotate the result by 90°?
Switch Row/Column is not what I meant an also not values in reverse order.
I included an illustration with the camera tool in the attached file. [In my real life data that solution with a camera tool looked horribly pixelated.]
In the article (and attached file) two pivot charts are used, but I am not limited by that. Actually with my own data I had too much struggle to align the two charts, so I switched to a pivot fed table instead. So please do not feel restricted by the pivot charts.
Thanks,
Matthias
I think you'd just use an XY scatter chart and add a dummy series to label the vertical axis.
See attached example.
Thanks Velouria! I was struggling with the vertical axis - to simply use labels is a great solution.
Thanks again,
Matthias