Two charttype on chart

  • Thread starter Thread starter shah firdaous via OfficeKB.com
  • Start date Start date
S

shah firdaous via OfficeKB.com

Hi, I have export the data to excel from Vb, then add the graph in excel
and set my secondary axis as..
..SeriesCollection(4).AxisGroup = xlSecondary
then how we set this group only as chatrtype as xlLine
and the primary axis values by Column charttype
 
Hi,

Try this,

..SeriesCollection(4).AxisGroup = xlSecondary
..SeriesCollection(4).ChartType = xlLine

Cheers
Andy
 
Back
Top