I have a chart using both primary and secondary axis.

The primary axis is the bar type and has 5 data sets. Three of them include: total spend for the month "X", portion of the total (X) that was for "Y", and portion of total (X) that was for "Z". The other two data sets are related to the three and must stay on the chart.

I'm looking for a way to have the "Y" and "Z" show as stacked (additional chart type) and not individual bars. Thus the stacked bar of Y and Z will equal X.

The secondary axis is already used (line type) and also must stay on the chart.

So, primary axis would have the bar and stacked type, and the secondary axis has the line type. Is this possible?

Appreciate any thoughts and help.

Thanks!