Reversed Single line chart with 2 TEXT Y AXIS LABELS and numeric X axis

[volyn]

Hello,

our customer asks for report, where he wants to see single line chart describing service satisfaction in 3 categories from 1 to 5

How modern is service ?   From  1 to 5 (Old fashioned to Very modern)

Graphical design ?   From 1 to 5 (Ugly to Very nice)

How expensive it is ?  From 1 to 5 (Expensive to Cheap)

And he wants to see single line chart where  1 to 5 will be on X axis and on Y axis will be on left Y axis will be text label for 1 and on right Y axis will be text label for 5.

To be honest I have no clue how to achieve it 

Attaching picture how it should look like.

Data are not important, I am able to do any kind of transformation, it is right now only about how to achieve visualization.

thanks 

[volyn]

Hello,

problem solved. I have used Charticulator.

First I prepared data to have description on Left and Right Y-axis in one row + on same row Rating (0-5) created by each customer (ID).  Rating value has summarization type "Average"

ID	Left Y axis	Right Y axis	Rating
1	Poor	Excellent	1.3
1	Expensive	Cheap	2.8
1	Ugly	Nice	3.7
1	Hard to learn	Easy to learn	2.5
2	Poor	Excellent	3.6
2	Expensive	Cheap	4.8
2	Ugly	Nice	2.1
2	Hard to learn	Easy to learn	2.5
3	Poor	Excellent	3.5
3	Expensive	Cheap	3.0
3	Ugly	Nice	4.0
3	Hard to learn	Easy to learn	2.0
4	Poor	Excellent	2.2
4	Expensive	Cheap	3.3
4	Ugly	Nice	4.5
4	Hard to learn	Easy to learn	2.8

Then in Charticulator I used trick described by another guy at Youtube. I have created 2 PLOT SEGMENTS.

Both of them have on X-axis Rating value, one plot segment has on Y-axis value "Left Y axis" and second plot segment has on Y-axis value "Right Y axis" . Second plot segment Y-axis apperance is set to "Opposite" and the trick is, that those 2 Plot segments are then set to be completely overlapping, because data in both of them are completely same.

Result is as follows, sorry I was not still playing with formatting.....

[PaulDBrown · Accepted solution]

Maybe possible using Charticulator?

https://charticulator.com/ 

[volyn]

you made my day sir, I did not catch info about this tool, after 2 hours of playing, I have job done !

[PaulDBrown]

It would be fantastic, and a important contribution to the community, if you could showcase how you achieved the visual (some screenshots maybe?)