How to plot 2 chart types on one graph in vba

[blh]

Good day,

I would like to create a chart in vba which contains 2 sets of data, both using the same x axis. The first must be a line graph, the second a staggered bar chart. This must be represented on one chart with data labels. Also, how do I change the colour of the plots?

Thank you

[Richard Buttrey]

So is the question how do I show both a line series and a bar series on the same chart?

Just select the series in question and use the Change Chart Type to select the type required.

Changing the colour of the plot points (markers) or lines / fill areas is just a question of selecting the appropriate object and formatting it accordingly.

[blh]

Yes, but how do I do this in VBA?

[Jon_Peltier]

ActiveChart.SeriesCollection(1).ChartType = xlLineMarkers
ActiveChart.SeriesCollection(2).ChartType = xlColumnClustered

[blh]

Thanks but this doesnt seem to work. Can you show me how to use the above syntax in an example?

[Andy Pope]

Why don't you post any example file. Manually create the chart so we can see what you actually need.