Auto expanding legend

[mark curtis]

I have a line graph set up with 20 rows of data. Sometimes several o
the rows have no data but they still have a representation on the grap
legend as the data series includes this.

Is there any way that I can only show legend entries for rows with dat
in?

Thanks
Mar

 

[Jon Peltier]

Mark -

Set up an autofilter in the sheet, and use it to hide blank rows (i.e.,
show nonblanks). The series won't plot and the legend entries won't appear.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______