Select the legend entry (the label not the line itself) and press Delete.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______
"P. Zicari" wrote in message
...
Thanks this worked for the line but is there a way to get the line out of
the
legend and still show the data for the other lines?
"Luke M" wrote:
Simply create another series of data with values of 94. You could format
the
text white so that you don't see these cells then.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"P. Zicari" wrote:
I have created a line chart that has data that goes from 82-104. It is
over
a 3 year period so I have 3 lines on the chart. I need to put a
horizontal
line across the chart at 94 to show a baseline and when the lines have
dipped
below this value. Is there a way to add this line. I am using Excel
07.
Thanks in advance.