Scatterplot chart question

JRCBoston

Board Regular
Joined
Sep 19, 2003
Messages
129
Hi,

Is it possible to have those data points that fall above the trend line one color and the data points that fall below the trend line a different color?

Thank you.
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Yes it is possible to color your dots differently based on a criteria. I don't know what your trend line looks like, so this may not fully solve your issue, this is how I would approach it:

The edit is done at the data set level, not at the chart level. Assuming you have data in 2 column format of X and Y axis, you need to split your Y column of data into two different Y columns, based on the criteria you have. Example: using an if formula, populate a Y_above and Y_below column using the formula of the trend line (compare y value against the output of the trend line function given the x value of the formula). With your new dataset of X and Y_above and Y_below (blanks in above where the value is below and vice versa), add the series to your chart and color them as needed.
 
Upvote 0

Forum statistics

Threads
1,215,549
Messages
6,125,473
Members
449,233
Latest member
Deardevil

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top