Set graph attributes in worksheet?

[SteveG]

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

 

[Andy Pope]

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