Inserting a 'Standard'

Hello Wizards

I've got my bar or line graph. Is there a clean way to place a 'standard'
or 'goal' line on the graph. i.e. if I want the goal to be 18.7 can I get
that to be a horizontal line that stands out.

TIA !
Sam

Would using the drawing toolbar to manually insert a line, possibly with some
descriptive text, work?


"Metolius Dad" wrote:

> Hello Wizards
>
> I've got my bar or line graph. Is there a clean way to place a 'standard'
> or 'goal' line on the graph. i.e. if I want the goal to be 18.7 can I get
> that to be a horizontal line that stands out.
>
> TIA !
> Sam

see http://peltiertech.com/Excel/Charts/...orzSeries.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Metolius Dad" <[email protected]> wrote in message
news:[email protected]...
> Hello Wizards
>
> I've got my bar or line graph. Is there a clean way to place a 'standard'
> or 'goal' line on the graph. i.e. if I want the goal to be 18.7 can I get
> that to be a horizontal line that stands out.
>
> TIA !
> Sam

The technique Bernard suggested uses a data series, which is not subject to
moving randomly the way a drawing object will do.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Peter Ellis" <[email protected]> wrote in message
news:[email protected]...
> Would using the drawing toolbar to manually insert a line, possibly with
> some
> descriptive text, work?
>
>
> "Metolius Dad" wrote:
>
>> Hello Wizards
>>
>> I've got my bar or line graph. Is there a clean way to place a
>> 'standard'
>> or 'goal' line on the graph. i.e. if I want the goal to be 18.7 can I
>> get
>> that to be a horizontal line that stands out.
>>
>> TIA !
>> Sam