Skip to Content
0

how do I flip a 100% stacking column chart

Oct 24, 2017 at 11:11 AM

23

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

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

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.


o1dcp.png (86.5 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 24, 2017 at 11:44 AM
0

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.


az1ig.png (71.8 kB)
ziexm.png (71.8 kB)
3m90k.png (73.7 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Can you share some sample data? I would like to try it.

0
Tammy Powlas
Oct 24, 2017 at 11:12 AM
0

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


tony1before.jpg (140.3 kB)
tony2after.jpg (158.9 kB)
Share
10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Oct 24, 2017 at 11:26 AM
0

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


tony3.jpg (58.0 kB)
Share
10 |10000 characters needed characters left characters exceeded