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.

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.

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.

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.