Hide line and legend on chart when data not present

[Teckstein]

I have a line graph that plots six lines from information in a data range. The data range is populated based upon which of 50 data sets the person wishes to view. This works great for data sets that have data for all six lines. However, some of the fifty sets have data for only two to five of the lines in the graph. When this is graphed, the line doesn't appear, but the legend for that line is still present. How can I adjust the chart to show only the lines and legend for instances when the data is present.

 

[tusharm]

The way I do this is to not use the legend. Instead, add one textbox linked to a worksheet cell for each line. Format this text box font to be the same color as the associated line.

Now, when there is no data to show, have the cell content become "" (a basic IF formula will suffice).

I have a line graph that plots six lines from information in a data range. The data range is populated based upon which of 50 data sets the person wishes to view. This works great for data sets that have data for all six lines. However, some of the fifty sets have data for only two to five of the lines in the graph. When this is graphed, the line doesn't appear, but the legend for that line is still present. How can I adjust the chart to show only the lines and legend for instances when the data is present.

 

[Teckstein]

Thanks - a simple but elegant solution.

The way I do this is to not use the legend. Instead, add one textbox linked to a worksheet cell for each line. Format this text box font to be the same color as the associated line.

Now, when there is no data to show, have the cell content become "" (a basic IF formula will suffice).

 

[tusharm]

Thanks - a simple but elegant solution.