Hi,
I think this will do it, but you ned to select the chart first.
ActiveChart.ChartType = xlLineMarkers
Thanks,
"shah firdaous via OfficeKB.com" wrote:
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
--
Message posted via http://www.officekb.com