RE: Trying to Change Axes

Hi,

As Jon has indicated in his response, your numbers contain more significant
digits than displayed, making each different from the other (e.g., 0.432 and
0.434 both are displayed as 0.43).
If you want to stick to 2 significant digits after the decimal, do the
following.
If your data are in A2:A131, use the following formula in B2 (and fill-in
the formula down to B131)

=ROUND(A2,2)

This creates a column of your numbers that have been truncated to exactly
two signficant digits after the decimal.

Now use the COUNTIF formula in C2 (and fill-down the formula to C131)

=COUNTIF($B$2:$B$131,B2).

Make an XY-scatter plot of columns B vs C.

Regards,
B. R. Ramachandran

"lost in charts" wrote:

> Hi, thanks for your response. I did what you recommended, but all the values
> in column B came out 1. Help!
>
> "B. R.Ramachandran" wrote:
>
> > Hi,
> >
> > One way (eventhough not very elegant!) is as follows:
> >
> > Let's say that your data are in A2:A131. Enter the following formula in B2
> > (and fill-in the formula down to B131).
> >
> > =COUNTIF($A$2:$A$131,"="&A2)
> >
> > Column B will now contain the number of occurrences of each value in Column
> > A (There will be redundant information when there are duplicates in Column A,
> > but they wouldn't hurt the graph).
> > Now make a plot of A2:A131 (y-axis) vs B2:B131 (x-axis)
> >
> > REgards,
> > B. R. Ramachandran
> >
> > "lost in charts" wrote:
> >
> > > I have a range of data that is listed in a column. I need to plot this data
> > > in terms of numbers of observations. For instance, the column reading down
> > > has the following points:
> > >
> > > 0.77
> > > 0.68
> > > 0.68
> > > 0.65
> > > 0.65
> > > 0.65
> > > 0.60 and so on...
> > >
> > > The values are sorted from highest to lowest and there are 130 data points.
> > >
> > > I need the data values on the y-axis and the number of times the value
> > > occurs on the x-axis. Can anyone offer advice? Thank you.
.

Relevant Pages

  • Re: How to loop through randomizer without getting the same digits
    ... regenerate the digits again, it gets the generates the same thing as the ... The sitecode F1Q is already in use, ... If Unique = vbYes Then ... Do Until Response = vbNo ...
    (microsoft.public.scripting.vbscript)
  • RE: Trying to Change Axes
    ... > If you want to stick to 2 significant digits after the decimal, ... >>> REgards, ... >>> B. R. Ramachandran ...
    (microsoft.public.excel.charting)
  • Me learn to count (one, two, free..)
    ... [This is a response to Frank's message but since I'm away from home ... for the Holiday weekend {you all have a safe one now...remember the ... I used "digits" because that made for a cheap funny. ... 'capital' quotation mark compared to a 'lowercase' quotation mark. ...
    (alt.lang.asm)
  • Re: A summary of my position so far.
    ... - whatever JJ is doing, your response was, well, was sorta bizarre in ... Finally, I'd like to indicate that digits and symbols, as numbers, ... particular applications (such as a sequence or calculus), ...
    (sci.logic)
  • Re: HOW MANY DIGITS OF PI HAVE PROPERTY X ?
    ... >>The answer should be a quantity only if you allow infinity as a quantity. ... > oo is a measure of quantity, an actual reference to the amount of digits in question, ... > dependeing on that..." ... your response answer though correct is not reduced. ...
    (comp.theory)