Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

area between two lines

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
Need Help
  • mahenkj2's avatar
    mahenkj2
    4 years ago

    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

     

mahenkj2's avatar
mahenkj2
Solution Sage
4 years ago

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