Forum Discussion
Separate positive values from negative values in same month (axis)
Hi everyone. As you can see in the stacked column chart below, I have some values that are separated by month and by technology in the same column. However, this is showing me the NET value and I'd like to differentiate how much was negative and how much was positive for the same month.
I added another column to my table which basically tell if certain value is positive or negative. For example, the next chart shows the pos and neg values for the month of August 2018.
My practical solution until know is to put two different charts in my report, one with the positive values and other with the negative ones, but I wanted to know if there's something I could do or a different approach to this.
Thanks a lot!
On the x axis of the chart, drag the new column that you have created (along with the month column which you already have there).
6 Replies
- Ashish_MathurSuper User
On the x axis of the chart, drag the new column that you have created (along with the month column which you already have there).
- dvhezHelper II
Oh silly me... I tried that before posting these but forgot to expand to the lower level. Thanks a lot!
- Ashish_MathurSuper User
You are welcome.