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

How to Create Milestone Chart in Excel

A milestone chart shows the date or time when a milestone is achieved in a graphical way. This graph must be easy to read, explanatory, and visual...

How to use Excel Box and Whiskers Chart

The Box and Whisker chart was invented by John Tukey in 1977. The graph was initially called Boxplot. Since then, it is being used in statical plottin...

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.