| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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: http://www.excelforum.com/member.php...o&userid=30881 View this thread: http://www.excelforum.com/showthread...hreadid=505609 |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
mickeymouse -
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 "mickeymouse" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > > 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 |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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. http://peltiertech.com/Excel/Charts/RunChtLines.html http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm Cheers Andy mickeymouse wrote: > 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 > > -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Combining a 2-D column graph and a 2-D line graph on the same char | Filippo | Microsoft Excel Charting | 3 | 23rd Feb 2010 01:34 AM |
| Changing Line Graph Colors in Microsoft Graph | Neil Ginsberg | Microsoft Access | 0 | 18th Nov 2008 07:45 PM |
| Changing Line Graph Colors in Microsoft Graph | Neil Ginsberg | Microsoft Access Reports | 0 | 18th Nov 2008 07:45 PM |
| How do I graph data daily as a line graph across a calendar format | =?Utf-8?B?R2xhbmk=?= | Microsoft Excel Charting | 3 | 23rd Nov 2007 10:05 AM |
| Cluster stacked graph AND line combo graph? | robotman@gmail.com | Microsoft Excel Charting | 6 | 14th Oct 2006 01:33 AM |
