ExcelBanter - xlChartType

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - xlChartType (https://www.excelbanter.com/excel-programming/313371-xlcharttype.html)

ojv[_2_]

xlChartType

What does an xlChartType value of -4111 signify and how is it arrived at? I
do not find it in the object browser.

ojv

Andy Pope

xlChartType

Hi,

Means it a combination chart. eg: Column and Line
To determine chart types of each data series use,

Activechart.seriescollection(1).charttype

Cheers
Andy

ojv wrote:

What does an xlChartType value of -4111 signify and how is it arrived at? I
do not find it in the object browser.

ojv

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

All times are GMT +1. The time now is 01:09 PM.