 |
 | 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 in area charts
howdy ive got a chart which gives production values by year for different countries. the problem is one country starts production in the middle of the data range and so excel draws the line from zero at the year before, so it rises slowly. i want the graph to jump straight to its value at the year production commences; how can i do this? (sorry if this is unclear, i would add a picture but i dont have hosting or anything!) thanks! Hi, If the line is rising from zero it would suggest that the periods before real values contain a value or formula that the chart is treating as zero. Either make sure the cells are really empty or your formula uses NA() for non values. Note this will not a vertical jump in the line rather the line will simply being at the Y value for that period. If you want a vertical line you will need to include an extra data point that has the period and a zero value. You then need to ensure the x axis is being plotted as true values and not categories other wise a double set of data for that period will be shown. Another way to get the dropline to zero would be to use custom Y Error bars, where only that period has a drop of the value for that period. Cheers Andy > howdy > [quoted text clipped - 9 lines] > > thanks!  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info Howdy again Thanks for the reply. >From what you say, I should have blank cells before the start of production? Well, I do but still it slopes down. I really need the vertical jump for this graph to make sense! Just for information here is a little bit of the data just to show you waht i mean TIME .... 1983 1984 1985 1986 Russia - - 4830 5260 FSU 5640 6150 - - Rest of FSU - - 1900 1920 So ideally the vertical line comes down in 1984 and the components continue on thereafter. > Hi, > [quoted text clipped - 11 lines] > Another way to get the dropline to zero would be to use custom Y Error > bars, where only that period has a drop of the value for that period. Are those - place holders for posting purposes or what you currently have in the cells? > Howdy again > [quoted text clipped - 30 lines] >>Another way to get the dropline to zero would be to use custom Y Error >>bars, where only that period has a drop of the value for that period. SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info sorry i meant to say, '-' indicates a blank cell. the figures are just rough but close enough (everything I have in the cells are values; no formulas at all). > Are those - place holders for posting purposes or what you currently > have in the cells? [quoted text clipped - 33 lines] > >>Another way to get the dropline to zero would be to use custom Y Error > >>bars, where only that period has a drop of the value for that period. Sorry missed the Area chart type in the question title. Only way to get area chart to drop vertically is to include multiple points for that period. So you need to expand the years information, hopefully the text wrapping doesn't destroy the layout. 01/01/83 01/01/84 01/01/84 01/01/85 01/01/85 01/01/86 Russia - - 0 0 4830 5260 FSU 5640 6150 0 - - - Rest of FSU - - 0 0 1900 1920 You need to go to the Chart Options dialog and set the x axis to be Time series rather than category. Set the Scale to be 1 years and format the numbers to be yyyy to get the correct axis labels. Cheers Andy > sorry i meant to say, '-' indicates a blank cell. the figures are just > rough but close enough (everything I have in the cells are values; no [quoted text clipped - 37 lines] >>>>Another way to get the dropline to zero would be to use custom Y Error >>>>bars, where only that period has a drop of the value for that period. SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info Thanks so much! It works like a dream and my chart looks amazing! Thanks again |
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.