putting graph as Line

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

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
>

Loop through every series in the chart's seriescollection and check the
axisgroup. If it is xlsecondary, set the series charttype to line.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> 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
>
>