Plot one stacked column on secondary axis

[maboho93]

Hi again everyone,

Please see the attached file for reference.

I am trying to make a stacked column chart based on a pivot table. Note that I'm not making a pivot chart, but an ordinary stacked column chart based on the pivot table.

I want to plot the headings Cost1, Budget 1, Cost 2, Budget 2 on the primary axis and Hours on the second axis. For some reason I am not able to achieve this. Can anyone please help me?

[Andy Pope]

You need to add another set of series for each activity by hours. These series can then be plotted on the secondary axis

[maboho93]

Thank you very much. This solved the problem