Conditional Formatting a Chart

[Andrew Ofthesong]

Hi... i found that OWC10 don't have these 2 properties for a .Serie object
(as does VBA): .XValues and .Value

So how can i get the values being represented by each point?

I'm programming a OWC chart, and i want to format each column conditionally
to a value...

Thanks,

 

[Thao Moua [ms]]

To get the value from each point, you need to execute
this code:

set c=webchart.constants
msgbox webchart.charts(0).seriescollection(0).points
(0).getvalue(c.chDimValues)

Depending on what chart type the series is, you'll need
to change the GetValue() method's argument.


Thao Moua
OWC Webchart Support

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm