1 of 1 people found this helpful
Hard to say without seeing your data and structure. However, adding a 'Stack Type' or similar dimension to your data comes to mind as an option. Basically you set the entire chart to stacked and you have two sets of data within a period - one which is the true stack and one which is a single value.
My source data;
This is a really good idea, you've given me something to think about - great idea!