Our next step is to represent the light gray bars in the background that reflect 100%.
The idea is to represent a second set of data that peaks at 100% (or 1) and to have that data set placed on the Secondary Y-axis to fall behind the original data set.
Let’s add two more series to the data set named “Full 1” and “Full 2”.
To bring the new data into the chart, a cool way to do this is by selecting the edge of the chart, then click and hold the blue grab-handle in the lower-right of the data and drag to the right two columns.
Another cool way to add data to a chart is to select the new data (in this case, cells D3 thru E12), click COPY, then select the chart, and click PASTE.
Now we have our updated chart with the new data set. The bars are tiny, but we’ll fix that soon.
Placing the New Data on the Secondary Y-axis
Double-click on one of the newly added data points (the tiny ones) to open the Formatting panel (right). Set the “Plot Series On” to Secondary Axis.
Select the remaining data points of the newly added data and set it to the Secondary Axis as well.
We’re getting closer, but there is still work to be done.