Stacked column - line combination

Hey all,

Yesterday I created this topic
Since I was dazzled by the things that didn't work in excel 2003.

Now I've been able to fix all and even improve some things on my code.
Except for one thing.

Thats the chart with stacked column on the left y-axis and a line on the right y-axis
xuLBEr4.png

Is that possible with this script? How can I get 2 columns (xlColumnStacked) to stack-up using this?

Please Login or Register  to view this content.

Sorry for opening a new topic about this. But the last got overloaded with non-related problems.

Try and incorporate this into what ever code you have.

Please Login or Register  to view this content.

Thnx Andy,
Took me a while to get it all sorted out. Didn't know that it was possible to change the charttype for just a series.

Code is below, just for those who want to know it.

Please Login or Register  to view this content.