In this video, we shade the area between two lines of a line chart to visualise the difference clearer.
There are many reasons to colour this area between the two lines. In this example, we use it to plot actual values against planned values.
We then tidy up the chart by replacing the Legend with an alternative way of differentiating the two lines.
Find more great free tutorials at;
https://www.computergaga.com
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
Connect with us!
LinkedIn ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1
Download
0 formats
No download links available.
Shade the Area Between Two Lines - Excel Line Chart | NatokHD