Hi guys,

This is proving harder than I thought it would. I have a relatively large set of data (2 columns, 100k rows) that I have plotted as a chart. What I would like to do, is somehow set the line colour as a gradient, that changes as a function of row number. The chart line gradient settings do not work like this.

Does anyone know how to achieve this effect?

Thanks a lot!

Dan