Stacked Area Chart problem - filling above line?

[dannytoone]

I normally find excel help just by googling my problem, but for some reason it seems nobody else has this problem.

I have a stacked area chart using dynamic named ranges that is currently giving me problems. When I first plot the chart, the the fill is below the line, but at the end of the range, the line connects back to the beginning of the range, messing up my fill area. (see first image)

In my effort to fix the problem, I toggled one of the data series to use a secondary axis, and all of a sudden it is filling in the area between the line and the top of the chart. (see second image)

But if I switch back so both lines are on the primary axis, this line still fills in above the line all the way to the top of the chart. (see third image)

I have tried redoing the chart, and the same things happen every time. I just need the chart to display like a normal stacked area chart.

What am I doing wrong? Is it how I have selected my data?

In case you need it, see the fourth image to see what my data looks like.