Forum

Notifications
Clear all

Rotate Dot Plot Chart

3 Posts
2 Users
0 Reactions
82 Views
(@matthias)
Posts: 49
Trusted Member
Topic starter
 

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

 
Posted : 05/12/2018 1:22 am
(@debaser)
Posts: 836
Member Moderator
 

I think you'd just use an XY scatter chart and add a dummy series to label the vertical axis.

See attached example.

 
Posted : 05/12/2018 6:16 am
(@matthias)
Posts: 49
Trusted Member
Topic starter
 

Thanks Velouria! I was struggling with the vertical axis - to simply use labels is a great solution.

Thanks again,
Matthias

 
Posted : 05/12/2018 1:13 pm
Share: