Scatter/Line Chart - hierarchy on Y Axis, Measure on X Axis?

[knowlec]

hi,

how do i flip a scatter chart/line chart (where line width is 0px and markers are on) so that my y axis is my hierarchy group which si text based questions and my x axis is my repsonse numberic values? 

it isnt letting me jsut drag them into the selection fields, i can only have it as the text hirarchy on the X acis and the measure on the Y axis, but i want this flipped

any ideas? 

[Anonymous · Accepted solution]

Hi, @knowlec 

This type of graph is often referred to as a line chart that reverses the axes. In this kind of graph, we place the measure on the x-axis and the categorical variable on the y-axis. This can be more useful in some cases, especially when the measure has a clear range or limit, or when we want to emphasize the change in the measure rather than the order of categorical variables.

You can try swapping the measure for a calculated column, otherwise the measure will not fit into the X-axis of the line chart.

Or you can use Python's matplotlib library to create graphs like this by simply swapping the values of x and y, for example:

import matplotlib.pyplot as plt

# Let's say we have the following data
values = [10, 20, 30, 40, 50]  # This will be our x-value
categories = ['A', 'B', 'C', 'D', 'E']  # This will be our Y-value

plt.plot(values, categories)
plt.xlabel('Values')
plt.ylabel('Categories')
plt.title('Line plot with reversed axes')
plt.show()

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.