Hi
I feel like this is going to be something incredibly simple, but I've been banging my head off the desk for half an hour now, it's time to turn to the experts!
Basically, I have a combined stacked line/stacked area graph. The area graph shows data up to today's date, while the line continues on to show future expectations. It does what I'd expect, except for one tiny issue - when there's just one data set, the area graph ends neatly and drops down in a straight line to 0. However, when it's stacked for some reason I can't seem to stop it tapering down on a slight angle towards 0 instead.
See attached for what I mean. It seems to have to do with the 'Show empty cells as gaps' option being disabled, but I'm not sure how to fix?
Any help would be massively appreciated.
Thanks!
help.xlsx
Bookmarks