Hi,

I have a line chart using 6 data series but I usually only have data points for 2 or 3 series and I want to only show a legend for the series for which there are data points.

Is there a way to set the chart to do this automatically?

Thanks in advance for any advice.