2.Click the chart. A blue bounding box appears around B2:B13 in the worksheet. Drag
the lower-right corner of the blue bounding box to the right to extend the series to
include the three values in column C. Initially, this line shows up as a red line on top of
a portion of the existing blue line.
3.On the Layout ribbon, use the Current Selection drop-down to choose Series 2. This
is the series you just added.
4.While Series 2 is selected, choose Design, Change Chart Type. Select the first area
chart thumbnail. Click OK. Excel draws a red area chart beneath the line segment of
June through August.
5.On the ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.