Hello community,
I created a table PivotChart where I am comparing expenses from this year and last year month by month. I would like my bars to be filled with a different color depending on the difference with the previous year. For instance, if I have spent more in January 2018 than I did in January 2017, have my bar for Jan 2018 red. If in February 2018, the expenses were less than in Feb 2017, then I want my Feb 2018 bar green.
Is it possible? I know that there is an option when dealing with positive and negatives numbers but I do not know how to format it in my case.
Thank you very much!
I created a table PivotChart where I am comparing expenses from this year and last year month by month. I would like my bars to be filled with a different color depending on the difference with the previous year. For instance, if I have spent more in January 2018 than I did in January 2017, have my bar for Jan 2018 red. If in February 2018, the expenses were less than in Feb 2017, then I want my Feb 2018 bar green.
Is it possible? I know that there is an option when dealing with positive and negatives numbers but I do not know how to format it in my case.
Thank you very much!
