Re: Unusual Y Axis Scale Question

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

Date: Mon, 09 Feb 2004 14:09:28 GMT

The easiest way to do what you want -- assuming I understand the
problem correctly -- is the following:

Plot the data and configure the y-axis scale with 'Log Scale' checked
as well as 'Values in reverse order'

Optionally, break up the data into chunks that make sense to you. Plot
each chunk on a separate graph using the customization above. 

-- 
Regards,
Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <uqXs2Xw7DHA.696@tk2msftngp13.phx.gbl>, gene.cooney@cox.net 
says...
> Bernard:
> 
> I was able to find an image of the "reciprocal graph" on the following
> Website:
> 
> http://www.wfubmc.edu/intmed/nephrology/Graph.htm
> 
> Thanks again.
> 
> "Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message
> news:%23ul7I9p7DHA.488@TK2MSFTNGP12.phx.gbl...
> > Hello Gene,
> > If you can plot it manually we expect to be able to do it in Excel. But
> you
> > are asking a lot of this group - you have not told us what to plot. Are
> you
> > thinking of the Michaelis Menten equation? Or is it some other function of
> > [S] that needs to be worked out?
> > We would love to help but need more info
> >
> > -- 
> > Bernard Liengme
> > www.stfx.ca/people/bliengme
> > remove CAPS in e-mail address
> >
> > "Gene" <gene.cooney@cox.net> wrote in message
> > news:u0kZCTn7DHA.1504@TK2MSFTNGP12.phx.gbl...
> > > I am trying to create what is referred to in the medical literature as a
> > > "reciprocal creatine curve." The data is rather simple -- just serum
> > > creatinine values (Y-axis) over time (X-axis), but the Y-axis scale is
> > quite
> > > unusual. The scale is not linear and it's not logarithmic. It's a scale
> in
> > > which the values appear to constantly accelerate. Thus, the distance
> > between
> > > 1 and 2 is greater than the distance between 2 and  3, the distance
> > between
> > > 2 and 3 is greater than the distance between 3 and 4, etc. Toward the
> very
> > > top of the Y-axis the incremental distance between values becomes
> > > infinitesimally small.
> > >
> > > Is this scale possible to recreate in Excel? Any help is sincerely
> > > appreciated.
> > >
> > >
> >
> >
> 
> 
>

Relevant Pages

  • Re: Unusual Y Axis Scale Question
    ... creatinine values (a measure of kidney function) over time. ... Although it would be easy to plot these data on a graph with standard Y-axis ... So, it's not the data that is complex, it's just the scale of the Y-axis. ...
    (microsoft.public.excel.charting)
  • Re: randomized white noise = white noise?
    ... You can draw lines on a Bode plot that are ... have a look at the relationships in your filter to see why you get ... The way around this is to scale "white" down, ... the safe scaling would be 0.408. ...
    (sci.electronics.design)
  • Re: Unusual Y Axis Scale Question
    ... > Hello Gene, ... > If you can plot it manually we expect to be able to do it in Excel. ... The scale is not linear and it's not logarithmic. ...
    (microsoft.public.excel.charting)
  • RE: How do I change my x-y scatter chart to show my column x values i.
    ... To not plot outliers, set the max. scale of the axis to a number that ... Double-click the axis; in the resulting dialog ... box, select the Scale tab. ... > was trying to plot. ...
    (microsoft.public.excel.charting)
  • Re: Unusual Y Axis Scale Question
    ... If you can plot it manually we expect to be able to do it in Excel. ... > creatinine values (Y-axis) over time, ... The scale is not linear and it's not logarithmic. ...
    (microsoft.public.excel.charting)
Loading