View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Willman Paul Willman is offline
external usenet poster
 
Posts: 9
Default Formatting a new seriescollection in a chart object

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