Line Graph with a Target Range in Excel 

I've been looking exactly for this. Thank you very much. I think this video is worth many likes🙃

Hi Alan.. great chart trick.. love the use of multi data series to get different effects like this. Your explanation was clear and concise. I was able to build my own version immediately after viewing the tutorial. Thanks and Thumbs up!

Simple, Short and clear. Thank you very much for the work presented. Really appreciate

Thank you for the tutorial, it is clear and simple to understand and has been a big help! 👍

Thanks a lot sir this video was absolutely helpful, I had no idea how to apply a target range in my graph. Really appreciate it 👌👌👌👍👍👍👍

thank you so much. just what I was looking for.

Another great idea, very well explained, thanks Alan

thank you so much this video was very helpful

Awesome! It helped me a lot! Thanks!

Thanks for well description :)

Thanks for sharing! Cool combo tricks! 🔥🔥

Great video. Thank you

Respect for you sir Thanks to shearing this useful video

Hi Alan, Do you have a Basic Chart and Graph tutorial? I have never done one before and need to know it for my Business Course I am doing online. I only ask because you explain things so well.

Bravo... thanks for sharing

very useful....keep it up👍

It is useful!

Thank you for the tutorial, but i have a few ranges not one !

Hey, Wondering if anyone can help me : How do I change the order of the X axis. My X axis has the values inverted. I want it to display left to right from cell 28 to cell 6 , but he is displaying from cell 6 to cell 28. How can I invert ?

WARNING: The gap width does not work when you have a date column (say, you're taking daily/weekly/monthly measures) where the values are entered as a date (e.g. 3/10/2023 or whatever your date format is)...then the gap width=0 setting in the series no longer "floods the area"; as a result you don't get a solid range bar across (only separated bars with gaps)...I think it should be considered a bug in Excel unless someone has a good reason why date differerence should forcibly cause a gap between bars. If you want a workaround, change the date values to a different format or label them as text. Hope it helps.

how to do the same in google sheets