How do I change one point in a scatter chart color

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed - 30 Mar 2006 15:05 GMT

I want to change teh colour of one point in a scatter chart, for example
Person Score Age time
A 25 20 1
B 20 14 1.5
C 22 22 0.75
D 23 23 1.25

I want to plot score against age, but highlight the point where the time is
less than 1. Any help would be appreciated

Reply to this Message

Andy Pope - 30 Mar 2006 15:16 GMT

Hi,

The easiest way is to add another series to plot just the points that
need a different colour.

Assuming your data example is in the range A1:D5 then add this formula
to E2 and drag down to E5.

=IF(D2<1,C2,NA())

Now add the series E2:E5 to the chart and format the series as required.

For more information in conditional charts have a look here.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy

> I want to change teh colour of one point in a scatter chart, for example
> Person Score Age time
[quoted text clipped - 5 lines]
> I want to plot score against age, but highlight the point where the time is
> less than 1. Any help would be appreciated

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

mstickma - 30 Mar 2006 15:41 GMT

You can pick just one point in a series, and format it differently.
Just click the series on the chart first, and you will see all the
points highlighted. Click again on the point within that series that
you want to re-format. Now you will see just the one point within the
series highlighted. Right-click on the highlighted point, and select
Format Data Point. From there you can change color, shape, weight, etc.
Somewhat precise clicking is required, so watch out for that.

Reply to this Message