Effective VBA Code for Conditional Charting

[hglamy]

Hello there,

in a line chart, I need to show 3 different markers / colors
for data points depending on whether the basic data to be
shown are =, > or < zero.

My attempts to code this in vba works, but very slowly.

I suspect there is an effective way to do this, but can't
find it. Does anyboday know better ?

Thank you in advance,

Kind regards,

H.G. Lamy

 

[Andy Pope]

Hi H,

Maybe you don't need VBA code at all.
Have a look at Jon Peltier's examples on conditional charts.
(http://www.geocities.com/jonpeltier/Excel/Charts/format.html#CondChart)

You should be able to modify the technique for lines.
Have one series for the line and 3 dummy series to display the
appropriate marker for the data points.

Hello there,

in a line chart, I need to show 3 different markers / colors
for data points depending on whether the basic data to be
shown are =, > or < zero.

My attempts to code this in vba works, but very slowly.

I suspect there is an effective way to do this, but can't
find it. Does anyboday know better ?

Thank you in advance,

Kind regards,

H.G. Lamy

--

Cheers
Andy

http://www.andypope.info

 

[hglamy]

Thank you, Andy, that would indeed work.

Whether Jon's sample can be extended to show
different (customized) marker point as I intended
to do, I'm still trying to find out.

Kind regards,

H.G. Lamy

 

[Jon Peltier]

Sure it can. Each of the series in the Line chart example has its own
markers.

- Jon