Hello,
I am plotting data in a chart that I want to show with dual axes. There is a stacked bar showing contribution of values by month across the X axis. The problem is that I have a YTD bar on the same axis with the value much higher than for each month. Makes sense. I want to creat a new Y axis on the right that has an appropriate scale for the YTD bar. The scale on the left has a scale that reflects the values for the monthly level data.

When I choose a new chart type and select two axis, it removes my stacked bars and puts them side by side. How can I do this? Thanks.

Rob