Add a horizontal line to a graph but not to the legend
 

I want to be able to add horizontal lines to my chart, in this case at 4% and
6% on the y-axis. The solutions I've seen so far suggest to add a series at
these points. The problem is that when I add a seires, my legend shows the
new series when I don't really want them to. Is there a really simple way
that I've overlooked so that I can just add a line at one y-value and all the
x values on the graph and not have it appearing in the legend?

Thanks

Add a horizontal line to a graph but not to the legend
 

I have just tested inserting an extra series in both xl2002 and xl2007 and if
you select the legend and then select the individual series legend
description so the markers are only around one entry in the legend, you
simply hit the delete key and it disappears.

In xl 2002 to turn them back on you have to right click the chart then chart
options and select Legend tab and uncheck the box and click OK to turn all
legends off. Repeat the operation and check the legend box to turn them all
on again.

In xl 2007, right click on the chart area (outside the plot area) and click
Reset To Match Style to turn them all on again. (However this resets
everything else also.)


Regards,

OssieMac


Regards,

OssieMac

"caramon2000" wrote:

I want to be able to add horizontal lines to my chart, in this case at 4% and
6% on the y-axis. The solutions I've seen so far suggest to add a series at
these points. The problem is that when I add a seires, my legend shows the
new series when I don't really want them to. Is there a really simple way
that I've overlooked so that I can just add a line at one y-value and all the
x values on the graph and not have it appearing in the legend?

Thanks

Add a horizontal line to a graph but not to the legend
 

Thank you very much. That solution works. In hindsight it was a silly
question, but thank you very much for replying anyway.

"OssieMac" wrote:

I have just tested inserting an extra series in both xl2002 and xl2007 and if
you select the legend and then select the individual series legend
description so the markers are only around one entry in the legend, you
simply hit the delete key and it disappears.

In xl 2002 to turn them back on you have to right click the chart then chart
options and select Legend tab and uncheck the box and click OK to turn all
legends off. Repeat the operation and check the legend box to turn them all
on again.

In xl 2007, right click on the chart area (outside the plot area) and click
Reset To Match Style to turn them all on again. (However this resets
everything else also.)


Regards,

OssieMac


Regards,

OssieMac

"caramon2000" wrote:

I want to be able to add horizontal lines to my chart, in this case at 4% and
6% on the y-axis. The solutions I've seen so far suggest to add a series at
these points. The problem is that when I add a seires, my legend shows the
new series when I don't really want them to. Is there a really simple way
that I've overlooked so that I can just add a line at one y-value and all the
x values on the graph and not have it appearing in the legend?

Thanks