Stacked Column & Line In Same Graph

  • I would like to make a graph with vba where there is a stacked column and a line which use two different axes. Any ideas how to do this?
    This is easily possible when manually using chartwizard, but I can't find any resources on how to do it through VBA.

    Attached is a snapshot of what the manually made final product looks like.

    So far, I have this which creates the chart for me, and I was hoping to format series (7) to be the line. Obviously, what I already have is incorrect.

    Thank you!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!