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

Set graph attributes in worksheet?
 

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/...nalChart1.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"SteveG" wrote in message
...
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