Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Add a baseline **kind of trend** to a Excel graph quickly
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
|
|||
|
|||
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
|
|||
|
|||
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: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Need to get slope of peaks on excel graph | Excel Discussion (Misc queries) | |||
Excel graph column and two lines. Help | Charts and Charting in Excel | |||
why is the y-axis label in the Excel graph always messed up? | Charts and Charting in Excel | |||
Excel sheet for workout jogging time and graph | New Users to Excel |