area between two lines

[Anonymous]

I have drawn an area chart. How do I remove the colour of the overlapped area? Thank you.

Area in the red lines is the one to be removed:

Any help given is appreciated

[mahenkj2 · Accepted solution]

Hello @Anonymous ,

Not sure if I understood it right. Basically, you would like to color (or remove color) between two areas. I considered that a calculated column Overlap, which is the minimum of both the main columns on each row can be your answer. Use this calculated column in the area plot and then color this as white (in the format pane, change data color for overlap column).

 You can get sample file here:

https://drive.google.com/drive/folders/1gHXGWMFlXGN0Vf-RI8xe6mbiKelLQFou?usp=sharing