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?
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.