I am using dynamic ranges to make an area chart so that there is a cliff instead of a slope down to zero. It is mostly working but I haven't figured out how to have the cliff go up from zero if it doesn't start on the first point on the x-axis. If I use a dynamic range then it simply shifts the data over to the y-axis. Here is my example:
I want the white portion (between 2012 and 2013) to be green. Everything else is correct. I have named ranges for Blue and Yellow, however if I make one for Green, then it gets shifted to start at 2009 instead of 2012.

I want the white portion (between 2012 and 2013) to be green. Everything else is correct. I have named ranges for Blue and Yellow, however if I make one for Green, then it gets shifted to start at 2009 instead of 2012.