 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / August 2006Vertical lines in a line chart
Hi, I have a problem with vertical lines in an excel line-chart. I have checked the available information in excel charts, but it does not work (Jon’s Excel and Charting Pages). I keep getting a sloping line and cannot place it on the month I want. I do not have days on the x-axis but months ranging from Jan. 1999 to June 2003. If I want a line at e.g. June 1999, will that be possible? Up till now I have done it manually. Thanks, Enna Hi enna, try an XY Scatter instead of a Line chart. Henk > Hi, > I have a problem with vertical lines in an excel line-chart. I have checked [quoted text clipped - 5 lines] > Up till now I have done it manually. > Thanks, Enna To elaborate on Henk's post, keep the main chart as a Line chart, but select the added series, go to the Chart menu and choose Chart Type, and select an XY type, with lines and no markers. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > Hi enna, try an XY Scatter instead of a Line chart. > Henk [quoted text clipped - 12 lines] >> Up till now I have done it manually. >> Thanks, Enna Hi It sort of works. At least I now get a straight line, but it is in the wrong place. It places itself on Jan. 1999 instead of on June 1999. My x-axis is in the following way: Jan. 1999 Feb. March April June July Aug. etc. continues Jan. 2000 Feb. etc. How do I specify that I want it on June? My mind is not very mathematically, so I think that it may be the bullet point: "If the x-values are text categories, enter the 'i' number" in yourAdd a vertical line description, that I don't completely understand. Sorry for bothering you again, but I often have to put these lines in charts. Enna "Jon Peltier" skrev: > To elaborate on Henk's post, keep the main chart as a Line chart, but select > the added series, go to the Chart menu and choose Chart Type, and select an [quoted text clipped - 23 lines] > >> Up till now I have done it manually. > >> Thanks, Enna Hi Enna - What are you using for the X value of the added series? If the first category is January (i=1), June is probably the 6th, so try using 6 (i=6). Move it to one side or the other of the category by using ±0.5 (i.e., 5.5 or 6.5), or fine tune it by making similar adjustments. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > Hi > It sort of works. At least I now get a straight line, but it is in the [quoted text clipped - 45 lines] >> >> Up till now I have done it manually. >> >> Thanks, Enna Hi Jon Thanks a lot. I have come a long way. I succeeded to put on two vertical lines, so I'll just go on trying. Enna "Jon Peltier" skrev: > Hi Enna - > [quoted text clipped - 59 lines] > >> >> Up till now I have done it manually. > >> >> Thanks, Enna |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.