Auto expanding legend

  • Thread starter Thread starter mark curtis
  • Start date Start date
M

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
 
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/
_______
 
Back
Top