Hi all,
I want to ask if it's even possible to somehow alternate the values in stacked bar chart, that one week the field 1 will be down and field 2 up and second week the opposite.
This is current state and next week should be in reverse.
Is that even possible with bar chart?
This is not possible with a standard chart. Having said that, you could spoof it by having 3 series instead of 2 (the third series being a duplicate of the first), and set the third series to zero in the first week, and the third series to zero in the second week, then assign the same colours to series 1 and 3
Hmm.. that sound promissingly.. I will give it a try.. going to play with it.. thank you 🙂
Thanks for quick answer
This is not possible with a standard chart. Having said that, you could spoof it by having 3 series instead of 2 (the third series being a duplicate of the first), and set the third series to zero in the first week, and the third series to zero in the second week, then assign the same colours to series 1 and 3
This was so great idea, it really works.. thank you so much 😁