If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|