Is it possible in Excel 2010 to add a series of scatter plot markers (XY chart) to a vertical clustered/stacked column chart. I can see examples of how to do it when the clustered chart is horizontal, but nothing on vertical.
My markers would show the total amount. My stacked bar is showing the components, one of which is a negative (See images below).
The total series goes onto the secondary axis, but then it’s not at all aligned with the other data. I'm unable to place it on the primary series. I'm sort of stuck.
Does anyone have an idea of how to work around this?
Any links or ideas greatly appreciated.
Thanks Michael.