 |
 | 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 / May 2008Values plotted outside of Axis scale
I'm plotting data in a scatter plot. The data values span -1 to ~16,000 and I want them on the Y axis. I do not want to plot the -1 values. I've set the Y axis scale minimum value to 0, but the -1 values are still displayed. I use the -1 values later in the chart, so replacing them with another # might be an issue. Outside of changing the minimum value until the -1 values disappear, is there any way to remove those values? Do you get data points outside of the plot area? How did you set your axis minimum? Did you set it to zero, then check the box that says Auto? Auto means let Excel assign the parameter, so you do not want to check Auto. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > I'm plotting data in a scatter plot. The data values span -1 to ~16,000 > and [quoted text clipped - 5 lines] > values > disappear, is there any way to remove those values? I manually set the minimum value for zero. I did not check the autoscale box. It seems to be an issue due to the large span of the data. If I try my setup with data over about 500, the -1 values appear. If the data contain points under ~500, the data disappear. Also, this is in Excel 2003. > Do you get data points outside of the plot area? How did you set your axis > minimum? Did you set it to zero, then check the box that says Auto? Auto [quoted text clipped - 16 lines] > > values > > disappear, is there any way to remove those values? I have seen this behaviour before with a very large data set. It was sent to me by a grad student years ago (I recall it had to do with birtds) and I am trying to recall the simple solution. If it comes in my dreams, I will let you know. Meanwhile, rest asssure it is likely not a problem with your PC or Excel installation If you send me the file (private email) I will have a look - but Jon is the chart expert best wishes  SignatureBernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme >I manually set the minimum value for zero. I did not check the autoscale > box. It seems to be an issue due to the large span of the data. If I try [quoted text clipped - 27 lines] >> > values >> > disappear, is there any way to remove those values? Well, that's weird. I have about 25 points, with Y values ranging between 0 and almost 5000. I set the min to 0 and the max to 5000, and inserted a small number of negative values. The points for -1 and -5 appear on the chart, and -10 does not. It looks like the -1 and -5 points are still centered on the axis line, and since 10 is one pixel above, -10 must be one pixel below and therefore is considered to be "off the chart". If I have a chance soon I'll submit this as a bug. Since it doesn't seem to occur in Excel 2007 (based on very limited testing), it's probably not worth submitting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ >I manually set the minimum value for zero. I did not check the autoscale > box. It seems to be an issue due to the large span of the data. If I try [quoted text clipped - 27 lines] >> > values >> > disappear, is there any way to remove those values? Thank you both. It's inconvenient, but I'll survive... :) > Well, that's weird. I have about 25 points, with Y values ranging between 0 > and almost 5000. I set the min to 0 and the max to 5000, and inserted a [quoted text clipped - 45 lines] > >> > values > >> > disappear, is there any way to remove those values? Are the data linked from somewhere else? You could change the link formula from =A1 to =IF(A1<0,NA(),A1) The NA() produces an error in the cell, but any marker-type series doesn't plot the point. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Thank you both. It's inconvenient, but I'll survive... :) > [quoted text clipped - 59 lines] >> >> > values >> >> > disappear, is there any way to remove those values? |
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.