In the google analytics and other online tools, you must have seen line charts. In these charts, you can see the shaded area under the curves. This shading looks cool, doesn't it? The question is, can we do this in Excel? How can we shade the area under the curve chart?
Yes! We can. We will need to use a combination of line-chart and area chart. Let's see how you can shade the area below a line chart in Excel through an example.
Here I have data on site visits of the week in the excel table.
We have inserted a line chart using this data which looks something like this:
Now the task is to:
Follow these steps to shade the area below the curved line:
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. I have used formula =C3 and dragged it down to get the same values.
2: Add Shaded Area Series: Now, right-click on the chart and click on Select Data. Click add series and select range D2:D9 as series value. Hit OK. You won't see any new curve but it is there. The new series covers the original series and that is why you can only see one series.
3: Change Shaded Area Chart Type to Area Chart: Right-Click on the series curve and click on the Change Series Chart Type. Now change the Shaded Area Series to Area Chart Type.
It has already started to look like a shaded area. We just need to do a little bit of the formatting of the chart.
4: Change the Formatting of Shaded Area to Gradient: Right-Click on the shaded area and click on the format data series. From fill and line, select ingredients to fill.
From the Directions, choose Linear Down.
Choose the colors you want to use. I want the blue theme so I use blue gradients.
5: Set the transparency of gradient to 50%: To make this chart even cooler, set the transparency of gradient colors to your need. I made it 50%.
6: Format other components to suit your requirements: The shade to the curve is added and the chart is almost ready but you may want to make it even better to suit your requirements. Remove the components from the chart that you don't need. Format the line and markers on the curve. Change the background color if you need it.
And it is done. You are ready to rock the presentation with this attractive visualization of curved data. You can use this in a PowerPoint presentation, excel dashboard, reports, etc.
I hope it was helpful. If you have any doubts regarding this topic or any other excel/VBA related topic, ask in the comments section below.
How to Highlight Maximum and Minimum Data Points in Excel Chart| Knowing the highest and lowest value in a data set is essential in almost all kind of reports. But in line and column Excel charts, it often gets difficult to identify, which value is highest and which value is lowest.
How to Insert A Dynamic Vertical Marker Line in Excel Line Chart | We can draw a vertical line on the chart manually but that just not smart. We would like to add vertical lines dynamically to mark a certain data point, say the max value.
How to Create Milestone Chart in Excel | A milestone chart shows the date or time when a milestone achieved in a graphical way. This graph must be easy to read, Explanatory, and visually attractive.
Waterfall Chart |This chart is also known as the flying bricks chart or as the bridge chart. It’s used for understanding how an initial value is affected by a series of intermediate positive or negative values.
Excel Sparklines: The Tiny Charts in Cell | The Sparklines are the small charts that reside in a single cell. Sparklines are used to show trends, improvement, and win-loss over the period. The sparklines are charts but they have limited functionalities as compared to regular charts.
Creative Column Chart that Includes Totals | To include the total of the clustered column in the chart and compare them with another group of the columns on the chart is not easy. Here, I have explained, how to smartly include totals in the clustered column chart.
4 Creative Target Vs Achievement Charts in Excel |Target vs Achievement charts is very basic requirement of any excel dashboard. In monthly and yearly reports, Target Vs Achievement charts are first charts the management refers too and a good target vs Achievement chart will surely grab the attention of management
50 Excel Shortcuts to Increase Your Productivity | Get faster at your task. These 50 shortcuts will make you work even faster on Excel.
The VLOOKUP Function in Excel | This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets.
COUNTIF in Excel 2016 | Count values with conditions using this amazing function. You don't need to filter your data to count specific value. Countif function is essential to prepare your dashboard.
How to Use SUMIF Function in Excel | This is another dashboard essential function. This helps you sum up values on specific conditions.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.