Formatting a new seriescollection in a chart object

P

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
 
T

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.
 
T

Tom Ogilvy

ActiveChart.SeriesCollection(2).ChartType = xlLineMarkers

ActiveChart.SeriesCollection(2).ChartType = xlColumnClustered


would be the basic approach.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top