Line and Stacked Area Combo help

Hi Everyone,

I'm looking to create a report showing forecasts and looking to use a combination of a line and stacked area (similar to the the attached image Untitled.png

The problem I have is that the stacked area plots to zero so doesn't look right. Can someone point me towards a tutorial on how to create this without the stacked area returning to zero?

Hopefully I've explained it enough and I will be very grateful for any help received.

Thanks
PH

Thanks for responding MrShorty, I am unable to upload a file at the moment but here is a sample of data and the chart it out puts is here Untitled.png

Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Week 13 Week 14
Group 1 5690557000 5592567000 5717779000 5616146000 5524311000 5878832000 5695341000 5655882000 5821058000 5776035000 5851726000 5798966000 5744254000 5680961000
Group 2 5307592000 5351925000 5459816000 5371482000 5385791000 5284122000 5192143000 5103673000
Group 3 109489000 112431000 133620000 149641000 172346000 190437000 204221000 213534000
Group 4 65134000 66884000 79489000 89020000 102527000 113289000 121489000 127029000
Group 5 52037000 53436000 63507000 71121000 81912000 90510000 97062000 101488000
Group 6 46727000 47983000 57026000 63863000 73553000 81274000 87156000 91131000
Group 7 45227000 46442000 55195000 61813000 71191000 78664000 84358000 88205000
Group 8 46727000 47983000 57026000 63863000 73553000 81274000 87156000 91131000
Group 9 52037000 53436000 63507000 71121000 81912000 90510000 97062000 101488000
Group 10 65134000 66884000 79489000 89020000 102527000 113289000 121489000 127029000
Group 11 109489000 112431000 133620000 149641000 172346000 190437000 204221000 213534000

Thanks
PH