Line Chart

[P. Zicari]

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.

 

[Luke M]

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.

 

[P. Zicari]

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?

 

[Jon Peltier]

Select the legend entry (the label not the line itself) and press Delete.

- Jon