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. If you have any doubts regarding this topic or any other excel/VBA related topic, ask in the comments section below.
You can use this in a PowerPoint presentation, excel dashboard, reports, etc. You are ready to rock the presentation with this attractive visualization of curved data. Change the background color if you need it.Īnd it is done. Format the line and markers on the curve. Remove the components from the chart that you don't need. I made it 50%.Ħ: 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. I want the blue theme so I use blue gradients.ĥ: Set the transparency of gradient to 50%: To make this chart even cooler, set the transparency of gradient colors to your need. From fill and line, select ingredients to fill.Ĭhoose the colors you want to use. We just need to do a little bit of the formatting of the chart.Ĥ: Change the Formatting of Shaded Area to Gradient: Right-Click on the shaded area and click on the format data series.
It has already started to look like a shaded area.
Now change the Shaded Area Series to Area Chart Type. The new series covers the original series and that is why you can only see one series.ģ: Change Shaded Area Chart Type to Area Chart: Right-Click on the series curve and click on the Change Series Chart Type. You won't see any new curve but it is there. Click add series and select range D2:D9 as series value. I have used formula =C3 and dragged it down to get the same values.Ģ: Add Shaded Area Series: Now, right-click on the chart and click on Select Data. Now the task is to: Add a shaded area under the line curve to the Excel Chartįollow these steps to shade the area below the curved line:ġ: 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. We have inserted a line chart using this data which looks something like this: Here I have data on site visits of the week in the excel table. Example: Create a Shaded Line Chart for Site Visit Let's see how you can shade the area below a line chart in Excel through an example. We will need to use a combination of line-chart and area chart. 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? In these charts, you can see the shaded area under the curves. In the google analytics and other online tools, you must have seen line charts.