I have a stacked bar graph which is using the year as dimension:
Year 2010 through Year 2013 all have bars that total 15%-20%.
However the year 2014 total is -89%.
Because of the limited size I have for the object it is jamming the 2010-2013 at the top and not even showing the data values, but the
-89% total bars for 2014 are showing fine,
I messed with the Static Min/max and can't get it to help. Isn't there a smooth way to handle when you have large discrepencies in graph data points? I thought there was some way to almost split your graph to account for large negatives?
Why is the negative value so disturbing? It's the reality. Numbers can't lie . Best Practices in data vizualizations and I wouls suggest to let it as it is and let the user plays. If the user want to focus on the positive number, he will made the selection manually.... then the chart scale will adjust automatically.
I don't mind the large negative numbers the problems is it is smashing the positive values to the top of the chart and you can't even see the data vales because the large negative bar is taking up all the real estate on the y axis.