RE: How do I change my x-y scatter chart to show my column x values i.

From: Tushar Mehta (tmUnderscore200310_at_tushar-mehta.SeeOhEm)
Date: 09/20/04 

Date: Mon, 20 Sep 2004 13:21:14 GMT

To not plot outliers, set the max. scale of the axis to a number that
makes sense to you. Double-click the axis; in the resulting dialog
box, select the Scale tab. 

-- 
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <BB129AAE-B37E-4AC6-A2F0-B5AA47537050@microsoft.com>, 
LHR@discussions.microsoft.com says...
> 
> 
> "LHR" wrote:
> I have solved te problem I alluded to below and thank whoever tried to help 
> me with a response. 
> The culprits were several very wrong values in the long columns of numbers I 
> was trying to plot. These skewed the displayed scale requirements and also 
> reduced the number of data points where a value was missing entirely. Hence I 
> could not get the program to plot the way it should. 
> It would be nice if the plotting program had some way of either ignoring or 
> force it to do so, of far away so-called "outliers".
> > I have fairly long columns of x and Y values. The x values range form 3039 to 
> > 3257 and the y values from 1.9 to 0.85. When I plot these on an x-y scatter 
> > charts the X values come out as 0 to 250 instead of with the 3000 value range.
> > 
> > In another similar set of columns I get exactly what I want with the x axis 
> > rangeing from 3000 to 3300. I cannot figure out why one set works right but 
> > the other does not.
> > 
> > What should I do to correct the first chart to the x range I need?
>

Relevant Pages

  • Re: Plotting logrithmic graph
    ... Plot the data, then double click on the Y axis, and on the scale tab, ... Jon Peltier, Microsoft Excel MVP ...
    (microsoft.public.excel.charting)
  • Re: plot function
    ... it is likely that "plt" can be used to create ... x axis except using different units, ... example, the two units are the same except for a scale factor difference, so ... is it possible to have a plot with 2 scales on the x axis corresponding to the same value ...
    (comp.soft-sys.matlab)
  • Re: How can I change the scale on the axis from 10^5 to 10^3?
    ... In a plot where the x axis runs from 0 to 200 000 Matlab ... automatically generates a scale with 0 to 2 and puts a 10^5 at the ... I want to change this scale to 10^3 for example. ...
    (comp.soft-sys.matlab)
  • Re: About ACF Plot in S+
    ... > scale of y axis to 0.4 instead of 1.0. ... to impose on the range of the y axis for the plot. ... See the help for the corresponding plot function, which in S-PLUS is ...
    (sci.stat.math)
  • Re: why my 2nd series scale change?
    ... Jon Peltier, Microsoft Excel MVP ... I want one scale at y left axis only but when I added another series ... I think I can delete the y right scale so the graph will be auto and no ...
    (microsoft.public.excel.charting)