One of the benefits of using the Gradient Option when deciding on the colour of a line in a line chart or graph is that it will change colour to reflect how high or low the point is in the line. You can even specify what is a low colour (perhaps red) and a high colour (greeen or blue).
Learn more at our live advanced Excel courses in South Africa. Visit www.AuditExcel.co.za Live Excel Training page