Line Chart points properties

[ElmerS]

Hi,

I managed to retrieve several "point" properties but couldn't figure out how to retrieve a point's value.

Here is a piece of my code:

Please Login or Register  to view this content.

BUT when I try: MsgBox .MarkerValue I get 'Runtime error 438' - object doesn't support...

Is there any workaround ?

Thanks, Elm

[teylyn]

MarkerValue is not a property of the Point Object. The Point Object properties are all about formatting, not about underlying data.

The value of the data point can be grabbed off the SeriesCollection.

Try something along these lines:

Please Login or Register  to view this content.

[ElmerS]

Thank you Teylyn,

This helped me to format the points according to their value.

However, I understand that if I want to format their colors according to the font color they depend of - I will need to browse the source cells in the sheet - or is there any short way around for that ?

Elm