3 Replies Latest reply on May 16, 2017 1:00 PM by Shinichiro Murakami

    How can I color each section of an overlapping area chart or color the differences in two area charts?

    Carol Au

      I'm trying to make an area chart for budget vs actual amounts.  I would like the area where the amount exceeds the budget amount to be red and where it doesn't to be gray.  I want the overlapping area to be white.  In my attached example on the Area Chart tab: I would like the blue section to be red, the red section to be gray and the purple section to be white. 

       

      I tried to make a calculated field for the area I want white, Lower Area, but I couldn't figure out how to add it to the existing area chart since it's already a dual axis.

       

      Any help would be appreciated.