Please refer to attached file. I am trying to create an area graph which aggregates values at Level 07. The problem is that the 'Other' category at Level 07 has negative values which is throwing the chart off ( see the green block in Chart 1). If I exclude 'Other' in Level 07 we get chart2 which looks good. is there a way to chart the other category and its negative value so that they appear on the chart in a more visually intuitive fashion? For example, the y-axis going down into the negative or something along those lines.
Shall appreciate your help.