Hi,
Does anybody know how I can get the series valuse on my line chart change colour if they are above or below the value in a specific cell?
I need to plot data to see if it falls inside two given limits. If it is above or below I would like it to change the data points of the series to red, but if it is within the limits remain as the default colour (black).
Any ideas? - Not VBA if possible!
Thanks in advance...
Does anybody know how I can get the series valuse on my line chart change colour if they are above or below the value in a specific cell?
I need to plot data to see if it falls inside two given limits. If it is above or below I would like it to change the data points of the series to red, but if it is within the limits remain as the default colour (black).
Any ideas? - Not VBA if possible!
Thanks in advance...