P0lar
Member
I have a line chart with around 75 line series on it. They all follow a similar trend but each line is different. My first 3 lines are the average and standard deviation for that point on the x-axis.
I have used worksheet.selectionchange and created a new series on the chart so that as I pick a column in the data, the new series changes to show that columns data in the chart as a bright coloured line.
I'd like to be able to just pick the series on the chart and this would change the highlight series, illuminating the whole of the selected line. Is this possible?
I have used worksheet.selectionchange and created a new series on the chart so that as I pick a column in the data, the new series changes to show that columns data in the chart as a bright coloured line.
I'd like to be able to just pick the series on the chart and this would change the highlight series, illuminating the whole of the selected line. Is this possible?