View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
JoeAtADA JoeAtADA is offline
external usenet poster
 
Posts: 3
Default Values 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?