Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Sorting a stacked bar chart

I have searched the forums here already for a solution for my question, but the way my data is set up doesn't seem to work for how my data is set up!   My data is looking at a series of projects, a...
Need Help
  • johncolley's avatar
    johncolley
    3 years ago

    Hi Anonymous ,

     

    If you are using the columns from your table like my image below you can simply rearrange them in the Visualisation pane to change the order they appear in the graph.

     

    If not can you please provide more information on how your visual is built

     

    If this answer solves your problem please mark it as a solution!

  • HoangHugo's avatar
    HoangHugo
    3 years ago

    Hi, I think that chagge order of field in Y axis

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks - this has worked! An interesting quirk though. I tried to do this method on my esxisting visual, but as I had already chosen a "sort axis" option, I couldn't unselect it and use the stacking of the fields to change the order - It had to remain checked as something.

 

I created a new column chart visual and checked, there is no default sort selected, so I am able to adjust the order with the fields directly. Interesting quirk, or am I missing something?

 

 

 

johncolley's avatar
johncolley
Solution Sage
3 years ago

Hi Anonymous , This is sorting the order in which columns appear left-to-right on the x-axis. Whereas the solutions provided are dealing with the order of items from top-to-bottom on the y-axis. Having something ticked or not ticked in the Sort Axis will not affect your ability to change the order of items within each column.