Excel line chart with a gradient fill beneath it - Excel Tips and Tricks - video Dailymotion

ExcelTips247

Learn how to create Excel line chart with a gradient fill beneath it.  I will also show you how do you gradient fill to the chart area in Excel, and how do I shade certain areas in Excel chart. And after this video you will be able to answer questions on can you do a gradient fill in Excel, and how do you change the background color of the plot area in Excel.   Here are the steps outlined in my video.   Insert Line Chart  1) Duplicate Total Sales column  2) Place cursor in dataset, and Ctrl + A  3) Insert ~ Charts ~ Line With Markers  4) Resize and reposition   Create Area Chart  1) Click on the line chart  2) Chart Design  3) Type ~ Change Chart Type  4) Change the Orange chart, to Area  5) OK   Gradient Area Chart  1) Right-click Area chart  2) Format Data Series  3) Fill & Line  4) Fill  5) Gradient fill   Excel line chart with a gradient fill beneath it,How do you gradient fill to the chart area in Excel?,How do I shade certain areas in Excel chart?,Can you do a gradient fill in Excel?,How do you change the background color of the plot area in Excel?,   Check out my complete suite of Microsoft Excel Tips and Tricks.  https://www.youtube.com/@RabiGurungXybernetics/shorts  https://www.tiktok.com/@xybernetics247  https://www.instagram.com/rabi.gurung247/  https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/  https://twitter.com/XyberneticsInc/media  https://www.reddit.com/r/Excel247/  https://www.facebook.com/XyberneticsInc/reels/   #microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Transcript

00:00If you want to create an area gradient chart like this, this is how you do it.

00:04First, you're going to duplicate the total sales on the side like this.

00:08Once this is done, put your cursor anywhere on your data set,

00:12and then press Ctrl A to select the whole data set table like this.

00:15Next, you go to Insert, Chart, Line Chart, and you're going to select a line with marker.

00:22And then after that, resize and reposition it nicely like this.

00:27Now, there's two line charts on top of each other.

00:29You're going to select any of the line charts.

00:31Just click on the line chart like this, and then go Chart Design, and over here, Change Chart Type.

00:38This one will come up here.

00:40Select Combo, and we're going to change the blue line into Stack Area Chart like that, and click OK.

00:48And next, to do the gradient, right-click on the area chart like this, and go Format Data Series.

00:55Go Fill and Line, under this Fill section, if it's closed, open it up like that, select Gradient, and you're done.

01:03All right, so.

01:04Now, here we go.

01:04Again, click OK.

01:07That's where we subscribe.

01:08So, let's see.

01:09Now.

01:09Here we go.

01:10Now, we need to block.

01:12Another one.

01:13Next, we're going to get on top of each other.

01:15Let's verify that there's a certain method.

01:18Let's do this.

01:20Everybody 현재 search

Excel line chart with a gradient fill beneath it - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended