How do I change one point in a scatter chart color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
Back
Top