Skip to Content
avatar image
Former Member

how do I flip a 100% stacking column chart

Hi I have created a 100% stacking column chart and want to show the measure with the smallest number stacked on top of the larger number, effectively flipping the stacking chart. I want to keep the data running order.

j7co2.png (66.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 24, 2017 at 11:24 AM

    Thanks Tammy, I don't have my 'date' data grouped by year, instead used the 'Hierarchy' function. I need to show a % improvement/deterioration through a timeline. My Chart suggests a gradual reduction in the number of 'rejects' which are easy to measure % vs scale %, but I would like to switch around to show the 'approves' increasing.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 24, 2017 at 11:44 AM

    Thanks again tammy, I tried the sort option and chart was order by the month with the largest number of data points. Unfortunately I lost the date order.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 24, 2017 at 11:12 AM

    Hi Tony - it looks like you are using Lumira 1.31x

    I would just "flip" the measures - see below:

    Before:

    After:

    Notice the measure order

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 24, 2017 at 11:26 AM

    Tony - could you select the "cog" next to your measures and then sort the other way as shown below

    Add comment
    10|10000 characters needed characters exceeded