Jon tells all at
http://peltiertech.com/Excel/Charts/...nalChart1.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Laoballer" wrote in message
...
is there a way to plot different colors for individual points on a
scatterplot with only 1 series?

my data looks like this

x y time

I would like to distinguish the color of the points by the time, e.g.
anything between 8am - 5pm one color and everything else another
color. I know you can do this with two series if I create a series
with time that's 8am-5pm and another with the other data. I'm
thinking I would need to program using vba, but not sure where to
start.

Thanks,