If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Line Graph Help
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 |
#2
|
|||
|
|||
Line Graph Help
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" wrote in message ... 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 |
#3
|
|||
|
|||
Line Graph Help
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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel should display linear equation of line drawn on graph. | landen99 | Charts and Charting | 2 | October 1st, 2005 02:34 PM |
I need to combine a bubble chart and a line graph (Excel 2003) | Rippbird | Charts and Charting | 1 | November 5th, 2004 12:23 AM |
Line Graph | Nan | Charts and Charting | 1 | October 8th, 2004 06:10 AM |
help with line graph | darci | Charts and Charting | 1 | February 22nd, 2004 12:52 PM |
Line Graph trendlines in correct representation | sri | Charts and Charting | 3 | December 4th, 2003 08:16 PM |