AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4K members online now
4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Color between lines

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi there, 

 

I have an issue. I have a time series chart with three lines. One line shows the actual number and the other two lines show the minimum and maximum of what the number should be. 

I need to highlight the area between the min and max line (color it). Can someone please tell me how to highlight an area between two lines? 
Or another solution for it with the data source. My data is on a google sheets.  

 

Thank you very much

 

Color between lines

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

What you could do is use an area chart instead of a line chart, and color the area for the actual number whatever color you want, then the area for min and max to white. You might need to play around with it, I'm not sure if there would be an issue of which area is in front (you want the white ones in front of the colored one, it sounds like).