Appearance of Data fields in Excel Charts

  • Thread starter Thread starter Sugith Kumar
  • Start date Start date
S

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
 
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.
 
Hi Tom,

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

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