ChartType anomaly (Excel)

[Stretchwickster]

I have a chart which varies in ChartType. It is either a xlColumnClustered or xlLineMarkers (with Series.Border.LineStyle = xlNone) chart. In another part of code I need to check which ChartType the chart is currently set to. The constant represented by xlLineMarkers is 65 and this is recognised properly initially. However, when the following line is executed the ChartType value becomes -4111 instead of 65:

ActiveChart.SeriesCollection(1).Border.LineStyle = xlNone

So when I do

if ActiveChart.ChartType = xlLineMarkers then

it doesn't recognise the Chart as being of that type, even when it actually is!

Why does this change occur to the ChartType when the LineStyle is set? And is it best to check the ChartType against -4111 to recognise it? Clive

 

[RobBroekhuis]

I know this is a copout, but couldn't you check for
.ChartType <> xlColumnClustered
if you only have two possible settings for this property?
Rob

 

[Stretchwickster]

Yes I was thinking that ;-) but wanted to make it a bit more readable! Clive

 

[RobBroekhuis]

Understood. I'd be pulling my hair out too ;-)
Rob