Combo chart in VBA

[bigjdawg43]

Hi,

In the attached, there is a portion of code that creates two charts on the "Charts" tab. They're both currently sturctured as clustered column charts, but I'm wondering how I can plot one of the series' (Sharpe Ratio and Information Ratio) on the secondary axis as a line chart with markers. How can I do this in VBA.

Thanks!

 

[bigjdawg43]

how do i attach the example?