software

Hello

I want to do a simple line graph - one line to go straight across and
another to be graphed according to some figures I have. Is it possible
to have the straight line touching the y-axis, but the other line not
touching it?
I can't seem to find a way given that they share the same x-axis, is
there anyway to bypass this??

I'd very much appreciate any tips, thanks --
mickeymouse
------------------------------------------------------------------------
mickeymouse's Profile: www.excelforum.com/member.php...oamp;userid=30881
View this thread: www.excelforum.com/showthread...hreadid=505609mickeymouse -

If you're using a Line chart type, please note that you can have more
complete control over the exact placement of lines (and points) by using an
XY (Scatter) chart type.

- Mike
www.mikemiddleton.com

quot;mickeymousequot; gt;
wrote in message
...
gt;
gt; Hello
gt;
gt; I want to do a simple line graph - one line to go straight across and
gt; another to be graphed according to some figures I have. Is it possible
gt; to have the straight line touching the y-axis, but the other line not
gt; touching it?
gt; I can't seem to find a way given that they share the same x-axis, is
gt; there anyway to bypass this??
gt;
gt; I'd very much appreciate any tips, thanks
Hi,

You can plot the straight line on the secondary axis. Then by enabling
the secondary x axis you can change this to cross between categories.
This will make the line touch the edge of the plot area.

Here are some examples of adding datum lines to charts.
peltiertech.com/Excel/Charts/RunChtLines.html
peltiertech.com/Excel/Charts/AddLine.html
tushar-mehta.com/excel/charts...nes/index.html
www.andypope.info/charts/averageline.htm

Cheers
Andy

mickeymouse wrote:
gt; Hello
gt;
gt; I want to do a simple line graph - one line to go straight across and
gt; another to be graphed according to some figures I have. Is it possible
gt; to have the straight line touching the y-axis, but the other line not
gt; touching it?
gt; I can't seem to find a way given that they share the same x-axis, is
gt; there anyway to bypass this??
gt;
gt; I'd very much appreciate any tips, thanks
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info