Forum Discussion

Anonymous

Not applicable

9 years ago

Centered 100% stacked bar chart

Hello, I want to create a 100% stacked bar chart with a centered center. The data contains satisfaction figures and I would like to make it clear at a glance which components are good and which o...

Icon for Advocate I rank

Advocate I

5 years ago

Have you been able to find a fix for this issue? I'm able to center the chart, however the sorting for the negative values is reversed.

MFelix
Super User
5 years ago
Hi RMO ,

Are you using a column to have the legend on your values or are they separate measures?

If you are using different measures your need to place them in the order you need so the sorting is correct. If you have a column that you use for legend you need to add an additional column to sort them out and your chart will be correct.
- RMO
  Advocate I
  5 years ago
  Thanks for the response. The issue isn't with the legend not sorting, because that's sorting correctly. It's the chart itself. If you look at OP's first image, the negative values in the chart are 3,2,1 when they should be 1,2,3. It's essentially correct because the values are ordered (-11 < -14) but we're looking for a workaround that reverses the order without taking the absolute value.
  - MFelix
    Super User
    5 years ago
    Hi RMO ,
    
    The questions is also regarding the legend, since the legend presents the order how your values are.
    
    I just did a simple column with 3 values:
    
    If I do the chart without using the Sort column to sort the category you get the result below:
    
    If you do the sorting you can see that the chart and the legend changes:
    
    Has you can see the sorting is important and should be done.