When plotting a time series with empty values for future dates (in Excel 2013), a regular area chart does what I want -- the shaded area ends abruptly:
regular area chart.GIF
When doing the same for a stacked area chart, the shaded area draws a line to zero, which I don't want:
stacked area chart.GIF
Any sense of why the different behavior and if it's possible to do what I want?
(The chart is a 12 week view that fills in a little more each week. I could avoid showing future empty values, but I like showing how many weeks are left until we hit 12, and keeping the scale identical each week. Also, it makes it easy to update without having to manipulate the chart each week.)
Bookmarks