palak
palak

Reputation: 41

How to switch segments in Bar chart

I am creating a bar chart in Workshop and then segmenting by a column. This column has values as 'Yes' and 'No'.

Currently the bar chart shows 'Yes' in the upper section and 'No' in the lower section. I would like to switch the values and show 'No' in the upper section of the bar chart. Is it possible? Thanks in advance!

Upvotes: 3

Views: 236

Answers (2)

Vaibhav Najan
Vaibhav Najan

Reputation: 11

Simplest Way to Swap the segments is to give the names to Segments alphabetically. I was struggling there, but once I changed the segment names, It worked for me.

In my case previously segment was 'planned' and 'actual', so alphabetically 'actual' was at top and 'planned' at bottom.

Now I replaced segment names from 'planned' to 'Future' and 'actual' to 'Past', so it swapped.

Upvotes: 1

Adil B
Adil B

Reputation: 16806

One quick way to do this is to switch the Y Axis Sort By settings to Key Ascending:

X Axis: Setting Key Ascending sort value

This will cause the No bar to appear before the Yes bar:

Workshop Yes/No Bar chart display

Upvotes: 2

Related Questions