Line Chart
 

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.

Line Chart
 

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.

Line Chart
 

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.

Line Chart
 

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.