Set graph attributes in worksheet?

I have a scatter plot with about 30 -40 points.

I would like to be able to set the attributes for each point in a
worksheet area. The idea is that points 1-4, 8-9 and 11 could be blue
squares whilst points 5-7, 10 and the rest are green circles. The
problem is that the groups are not contiguous and change from day to
day.

Is this possible?

Steve

Hi,

Simplest thing is to use multiple series. Then either manually or with
formula populate the appropriate points in each series.
This is a similar approach to the one used for conditional charts
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"SteveG" <steve31530 RemoveThis @gmail.com> wrote in message
news:376f0b19-e5cc-44b0-8aa6-3e4aee185168@l2g2000yqd.googlegroups.com...
>I have a scatter plot with about 30 -40 points.
>
> I would like to be able to set the attributes for each point in a
> worksheet area. The idea is that points 1-4, 8-9 and 11 could be blue
> squares whilst points 5-7, 10 and the rest are green circles. The
> problem is that the groups are not contiguous and change from day to
> day.
>
> Is this possible?
>
> Steve