Appearance of Data fields in Excel Charts

[Sugith Kumar]

Hi,

In a VB program, I'm creating Excel Charts. I use
ChartType = xlColumnStacked to show the data fields to
appear as Columns stacked one over the other. I have 7
data fields. But I want first two data fields to appear as
xlLineMarkersStacked, keeping the other 5 as
xlColumnStacked . How do I do this? Any idea?

Thanks in advance
Sugith

 

[Tom Ogilvy]

believe you can put them on the secondary axis and change the chart type for
the secondary axis.

Look at some of the provided combox charts types in the chart wizard and see
how they are set up for ideas on how to do this.

 

[Sugith Kumar]

Hi Tom,

Thank you very much for the reply. Could you please tell
me how to accomplish this thru VB code?

Thanks
Sugith

 

[Tom Ogilvy]

Turn on the macro recorder while you do it manually and you will see the
basic code you need.