Charttype issues using if then

[Saekken]

Hi

Goal:
Format charts differently depending on type

My code:
If ActiveChart.ChartType = xlColumnClustered Then Call Ejmellem

Problem:
Somehow vba can't read which type the active chart is when running the code and therefore the Ejmellem isn't called.

Half solution:
For example if I define

ActiveChart.ChartType = xlColumnClustered

just before my code the private sub is called. But I want my code to work on different types so I dont have to make a macro for each one.

Can anyone help me?

Thanks in advance //Saekken

 

[Saekken]

Problem solved.

I didnt realise the type is changed when editing formats of labels, axes etc. - but of course!