How to create a visualization showing normal range overlaid on sample metrics in Excel?

Usman Raza
Towards Data Science
10 min readDec 29, 2019

--

What’s in this article: A step-by-step guide for creating a chart that shows normal range overlaid on mean, min and max values for multiple series of data. In other words, an Actual vs Target chart. By the end of this tutorial, you will be able to produce something like this in MS-Excel:

--

--