Words Graph Fill Between Line Chart

What I want to be able to do is highlight the area between the 1,285,351 and the 90,680, similar to an area chart. I can make all of the 1,285,351 an area chart bt it throws off the bottom of my graph. I wish I could attach a picture of my graph to give you a better idea. Thank you.

Step 3 Utilizing Change Chart Type Feature to Shade Area Between Two Lines in a Chart. Right-click on the chart and select Change Chart Type. In the Change Chart Type window, go to All Charts gtgt Combo chart gtgt select Custom Combination. Change the chart type for both the Jan and Price Change lines to Stacked Area. Press OK. Double-click on the Jan line to open the Format Data Series window.

The second series for the Stacked Area Chart is a new data set that you define as the values for Line 2 minus the values for Line 1. After creating the stacked area chart, you can copy your data for Line 1 and Line 2 and paste into the chart, then go to Chart Tools gt Design gt Change Chart Type, choose Combo from the list of All Charts, and

The Gap column calculates the difference between the Top and the Hidden Base, E2-C2, E3-C3, etc.. Select the entire data set, A1 through F8, and create a Stacked Area chart. Notice how the x-axis has quotPeriodquot as a label. Next, select the quotBottomquot series, which should be on top, by clicking on it and changing the series type to a

Make the other series go from the bottom to the top of the filled region. Use no fill to format the first series, and any desired fill for the second. See Fill Under or Between Series in an Excel XY Chart. -

Unfortunately, I already tried the area chart and it fills the area between the line and the X axis which is not what I want to do. What I would like to do is fill the area between the lines like shown in the chart below If you have any idea on how to do it, that would really help me! Thank you!

- first I set the two series line chart - then I added the first series again, changed the chart type to stacked area chart and set the fill to No color - finally I added the third series the data of column D, I changed the chart type to stacked area chart. My Graph is the one on the bottom left. Hello, Mario

This technique plotted the XY chart data on the primary axes and the Area chart data on the secondary axes. It also took advantage of a trick using the category axis of an area or line or column chart when used as a date axis, points that have the same date are plotted on the same vertical line, which allows adjacent colored areas to be separated by vertical as well as horizontal lines.

4. In the Change Chart Type dialog box, change the chart type of the Base and Difference series to Stacked Area and click the OK button to save the changes. The chart now is displayed as follows. 5. Select the largest highlighted area in the chart, and then click Format under the Chart Tools tab gt Shape Fill gt No Fill. 6.

- In the dialog box, select Line from the list of chart types and click OK. This will change the selected data series to a line chart and overlay it on top of the bar chart. - You can adjust the formatting of the line chart, such as the color, width, and style of the line, by right-clicking on it and choosing Format Data Series from the context