This is a brief follow up to the original article found here: http://www.illuminateandenumerate.com/2013/11/how-to-fill-shade-between-lines-in.html
This follow up clarifies how to set up the data set, and attempts to answer the question about having three data lines.
How to Set Up the Data
In the first post I used the following data set where Bottom was a copy of Hidden Base:
From the first article:
- The second column, “Hidden Base” and the last column, “Bottom” are the same data. I actually used =C2, =C3, etc… for column F.
It works better the other way around!
- Make the Hidden Base a copy of the Bottom as in, =F2, =F3, etc..
This way it's obvious that the Bottom column is your bottom data set.
You can download my example workbook here: Example Excel Workbook
Three Data LinesSomeone asked about having three data lines. It works as long as any data line only intersects one adjacent data line. This is because the gap is simply the difference between two adjacent lines.
This is an example where the top data line dips below the middle data line.
When the top line dips below the middle and the bottom, then we see this:
Gap 2 is showing the distance between the top and middle lines.
This is also in the example workbook above.