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

G

Guest

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!
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding baseline and goal lines to a column graph 1
Normalize Graph 8
Trend Lines 1
trendlines for two phases 8
scatter chart won't accept primary axis 4
Problem creating a logarithmic trend line 2
Can I add a baseline value to a chart? 1
how to generate a polynomial regression graph with 90% CI? 1

Top