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

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.

--
Regards,
Tom Ogilvy

"Paul Willman" wrote in message
...
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