How do you shade area under a line graph?
Add a shaded area under the line curve to the Excel Chart
- 1: Add Helper Column to Data- To add a shaded area to this line chart, we need a helping column that has the exact same value as the original series has.
- 2: Add Shaded Area Series: Now, right-click on the chart and click on Select Data.
How do you shade under a line graph in Excel?
To do achieve the shaded area under the line chart, we have to trick Excel by adding another data series. Select the Sales row and copy it to the row below so there are two identical data series. Then select the chart you made so the data table is highlighted. The date axis is highlighted in purple.
How do you highlight an area under a graph in Excel?
Right click on the “Area” series (which is still of type XY), and choose Change Series Chart Type. In Excel 2013, the Change Chart Type dialog appears. Click the Chart type dropdown in the Area series row, and select Area or Stacked Area (doesn’t matter which in this case, since there’s only one area series).
How do I shade a graph in Excel?
Select the cells that you want to apply shading to or remove shading from. For more information on selecting cells in a worksheet, see Select cells, ranges, rows, or columns on a worksheet. , and then under Theme Colors or Standard Colors, click the color that you want.
What is stacked area chart?
In a stacked area chart, all of the lines are stacked on top of each other over a straight baseline at the bottom of the stack. With a stream graph, the baseline is set through the center of the chart, and the areas symmetrically gathered around the central line.
How do I fill an area between lines in Excel?
Re: how to Fill area in between lines After creating the stacked area chart, you can copy your data for Line 1 and Line 2 and paste into the chart, then go to Chart Tools > Design > Change Chart Type, choose Combo from the list of All Charts, and choose Line or Stacked Area for the different series.