 |
 | 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 / September 2006Vertical line isn't vertical!
Hi All - I need to insert a 'dynamic' vertical line into a line-chart -- the line will separate the Past from the Future. After some searching, I found Jon Peltier's site, which had some really good information on it ..... but I just can't get it work! Right now, the vertical line is in the correct spot and 'moves' properly -- but the line isn't quite horizontal, more of an 85deg angle (like this: / ). The vertical line is definitely setup as an XY scatter connected with a line (no markers). What am I doing wrong? Or did I miss a step? Thanks, Ray Hello again ... Some additional information....when I mouse-over the two endpoints, I get the following information: Point 1 - Series 'today', Point '37' (1,0) Point 2 - Series 'today', Point '37' (2,1) Where are the 'coordinates' coming from and how do I change them? I saw on Jon's example file that the coordinates actually has a different format (the 'Point' is the first number in the coordinates). thanks, ray > Hi All - > [quoted text clipped - 10 lines] > > Thanks, Ray Aren't the coordinates on the sheet where the series gets its values? If it's a vertical line, you change one X value in the series' source data range so that both points have the same X value. If the chart is embedded on the sheet, select the series, and the source data for the series will be highlighted with light rectangular outlines. If you can't find the source range, go to Source Data on the Chart menu, click on the Series tab, select the 'today' series in the list, and use the X and Y value input boxes to find the source data ranges. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > Hello again ... > [quoted text clipped - 23 lines] >> >> Thanks, Ray |
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
|
©2009 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.