Add a baseline **kind of trend** to a Excel graph quickly

#1 05-24-2005, 03:06 PM

Hi,

I would like to quickly add a baseline trend to a graph without having to
write (exemple: Value 30) the same number of time as of my X axis data.

Actually, I have to "emulate" a false line.

Is there a way to enter only one number and it automatically add the
baseline trend so we can see variance easily.

Thanks!
--
Mathieu

#2 05-24-2005, 03:06 PM

This may help you

http://www.peltiertech.com/Excel/Cha...orzErrBar.html

"Mathieu" wrote:

> Hi,
>
> I would like to quickly add a baseline trend to a graph without having to
> write (exemple: Value 30) the same number of time as of my X axis data.
>
> Actually, I have to "emulate" a false line.
>
> Is there a way to enter only one number and it automatically add the
> baseline trend so we can see variance easily.
>
> Thanks!
> --
> Mathieu

#3 05-25-2005, 01:06 PM

If your "false line" is meant to be a "point-to-point trend line" so that you
can easily see variance among the midpoints, then this array function might
help. See:

Subject: RE: Missing functions and commands 5/1/2005 8:52 AM PST

By: silver23 In: microsoft.public.excel.programming

"Mathieu" wrote:

> Hi,
>
> I would like to quickly add a baseline trend to a graph without having to
> write (exemple: Value 30) the same number of time as of my X axis data.
>
> Actually, I have to "emulate" a false line.
>
> Is there a way to enter only one number and it automatically add the
> baseline trend so we can see variance easily.
>
> Thanks!
> --
> Mathieu

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)