How do I change one point in a scatter chart color

E

Ed

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to getting text labels to show up in scatter chart. 0
Data points in chart incorrect 0
offset scatter plot points 1
Scatter Point chart labels are missing 1
XY Charts 1
How do I put multiple lines on a scatter chart? 1
Change color of points of scatter plot 1
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0

Top