Thanks:  0
Likes:  0

# Thread: Conditional Format of Scatter Chart

1. ## Conditional Format of Scatter Chart

Hello

I have a scatter chart created from a data series in a column.
Is it possible to change the color of the points that fall below a certain value to red?
Can someone point me in the right direction please?

Thanks
Joe

2. ## Re: Conditional Format of Scatter Chart

Hi,

Forn anything non-standard with Excel charts I always look at Jon Peltier's site. In this case I found this: Conditional Formatting of Excel Charts - Peltier Tech Blog

The basic process is that you will probably need to plot three data series, not just one. Start with your original x and y-axis values then create formulas in the next two columns that spliut the points according to how you want them plotted. So, red points in one column and the others in the next one.

Then you plot all three sets of y values. The first one is complete and you keep the lines but hide the markers. The second and third ones you hide the lines but keep the markers.

My test data looked like this:

Excel 2013
ABCD
1XYLowNormal
210.229564#N/A0.229564
320.50972#N/A0.5097204
430.0583070.058307#N/A
540.607066#N/A0.6070662
650.0754970.075497#N/A
760.467152#N/A0.4671523
870.261374#N/A0.2613741
980.667641#N/A0.6676411
1090.984997#N/A0.984997
11100.735486#N/A0.7354864
12110.206556#N/A0.2065561
13120.0996640.099664#N/A
14130.939593#N/A0.9395929
15140.847493#N/A0.8474926
16150.326043#N/A0.3260425

Sheet3

Worksheet Formulas
CellFormula
B2=RAND()
C2=IF(Sheet3!\$B2<0.2,Sheet3!\$B2,NA())
D2=IF(Sheet3!\$B2>=0.2,Sheet3!\$B2,NA())

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•