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

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.

--
Regards,
Tom Ogilvy


"Sugith Kumar" wrote in message
...
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

Hi Tom,

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

Thanks
Sugith


-----Original Message-----
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.

--
Regards,
Tom Ogilvy


"Sugith Kumar" wrote in message
...
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


.

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

--
Regards,
Tom Ogilvy

"Sugith Kumar" wrote in message
...
Hi Tom,

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

Thanks
Sugith


-----Original Message-----
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.

--
Regards,
Tom Ogilvy


"Sugith Kumar" wrote in message
...
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


.