How do I change one point in a scatter chart color
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 |
How do I change one point in a scatter chart color
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/...nalChart1.html Cheers Andy Ed wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
How do I change one point in a scatter chart color
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. |
All times are GMT +1. The time now is 02:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com