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;
[ Ссылка ]
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► [ Ссылка ]
Excel VBA for Beginners ► [ Ссылка ]
Advanced Excel Tricks ► [ Ссылка ]
Excel Formulas Made Easy ► [ Ссылка ]
Creating Sports League Tables and Tournaments in Excel ► [ Ссылка ]
Connect with us!
LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]
Shade the Area Between Two Lines - Excel Line Chart
Теги
excel line graphshade area between two lines excelshade area under curve excelComputergagaexcel tipsexcel tutorialalan murrayexcel chartsexcel charts and graphs tutorialexcel charts advancedmicrosoft 365shade between two lines in excel chartshade between two lines excelcolour area between two lines excelcolour between two lines excelexcel fill area between two linesadvanced excel tutorialexcel colour area between two lines