Formatting a new seriescollection in a chart object

[Paul Willman]

I have a VB6 app that creates some SeriesCollections in a chart

chtChart.Chart.SeriesCollection.NewSeries

where chtChart is defined as

Dim chtChart As Excel.ChartObject

I need to know how to tell the chart that the new series is a vertical bar
or a horizontal line. I've been unsuccessfull in identifying this property
when playing around in Excel.

Any help you can give me is most appreciated.

Thanks,

Paul Willman

 

[Tom Ogilvy]

do you mean whether the chart is to be a Column Chart or a Bar Chart?

Are you talking about the whole chart or is it a mixed chart

or are you talking about something else, where the line might be an
indicator of a goal value or the current date as an example.

 

[Tom Ogilvy]

ActiveChart.SeriesCollection(2).ChartType = xlLineMarkers

ActiveChart.SeriesCollection(2).ChartType = xlColumnClustered


would be the basic approach.