Forum Discussion
Stacked Area Chart: Negative and Positive values not oriented at 0
Hello!
I have a stacked area chart with positive and negative values. I would like both of their "baselines" to be zero.
However, this is not the case:
Whenever there are both positive and negative values, the bottom line gets "pulled up" to meet the top of the top lines. The values between 2020 and 2021 are around -50 to -55 but here they're showing up around the 40 mark.
I understand why this might happen, but for my purposes I'd like it all to be at zero.
I found I could achieve this using lines on the stacked bar/column chart, but this requires a different column for each line which for my purposes is tedious:
I know this can be displayed as a stacked bar chart itself, but I prefer the line visual.
Does anyone have advice about how to fix this? How difficult is it to create a custom visual from an existing one?
Thanks in advance!
2 Replies
- Greg_Deckler
Community Champion
Custom visuals are no joke, they aren't rocket science but they are next, next finish either.
Can you share sample data and such so that we can do some experimentation with this? I personally have no idea why -55 wouldn't be displayed as -55 but instead be displayed as 40.- AnonymousNot applicable
Here's an example dataset with fakes numbers but in the same format.
I'm plotting "Date" along the x axis, "Value" along the y axis, and want the colors split by "Type"
The visual turns out like this:
All the negative numbers are from -60 to -65 but as you can see they are getting "pulled up" as well.
Thanks!