How to Creatively Highlight Above and Below Average in Excel Line Chart

To visually see when the line on the chart is above or below the average of the series, we can simply insert an average line on the chart. It will loo...

How to Highlight When Line Drops or Peaks in Comparison Excel Chart

Let's say we have this week's site visit data and last week's site visit data. I want to compare week 2 data with week one visually. Now, there...

How to Add Shade to Curve Line in Excel Chart

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. Thi...

How to Highlight Maximum and Minimum Data Points in Excel Chart

As they say, a picture worths a thousand words, this is true in all fields. Knowing the highest and lowest value in a data set is essential in alm...

How to Insert A Dynamic Vertical Marker Line in Excel Line Chart

The line charts are fantastic tools in Excel to visualize records over time. And while working with line charts, we get the need to add a vertical...

Create Sunrise Chart in Excel

You must have seen sunrise charts on different weather sites for depicting daylight time in different months or weeks of years. Being a creative ind...

Creative Column Chart that Includes Totals in Excel

In previous tutorial, we learned how to plot a clustered chart in excel. It was an Sales in Months chart of different cities. The chart that we create...

Terms and Conditions of use

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.