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

--
Message posted from http://www.ExcelForum.com

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

mark curtis < wrote:

> I have a line graph set up with 20 rows of data. Sometimes several of
> the rows have no data but they still have a representation on the graph
> legend as the data series includes this.
>
> Is there any way that I can only show legend entries for rows with data
> in?
>
> Thanks
> Mark
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>