Results 1 to 2 of 2

Conditional Format of Scatter Chart

This is a discussion on Conditional Format of Scatter Chart within the Excel Questions forums, part of the Question Forums category; Hello I have a scatter chart created from a data series in a column. Is it possible to change the ...

  1. #1
    Board Regular
    Join Date
    Mar 2008
    Posts
    88

    Default 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. #2
    MrExcel MVP RickXL's Avatar
    Join Date
    Sep 2013
    Location
    UK North Midlands
    Posts
    4,182

    Default 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())

    RickXL

    Excel 2013 and Windows 10

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com