Does anyone have any ideas how to split an area chart along the x - axis with a perpendicular line so that I can differentiate between historic actual figures and forward looking forecast figures - feels like it should be a really simple thing too achieve, but haven't found any solutions so far. The attached was done using drawing tools to achieve what was needed, but I'd rather it came directly out of Excel (or PowerPoint). I know I could use bar charts to achieve something similar, but as you can see from the attached I wanted to use dual y - axes to differentiate between sales and pipeline. Any thoughts would be very welcome!