+ Reply to Thread
Results 1 to 7 of 7

Scientific Notation when graphing

  1. #1
    Bates Senior Thesis Researcher
    Guest

    Scientific Notation when graphing

    Hi I'm using Excel 2003 and I am trying to make a column graph where the
    y-axis represents bacterial growth in log form. Therefore, the numbers are
    quite large. I need the axis to say "10^3" and not "1.E03". I am confused
    as to why the only scientific notation that I can find is written as "1.E03"
    because no scientific journal that I have come across uses this notation on a
    graph. I have tried using the "custom" tool and adding "^3" to the end but
    the number ends up being quite large and not anywhere what I need it to be.
    Thank you.

  2. #2
    Jon Peltier
    Guest

    Re: Scientific Notation when graphing

    Unfortunately, Excel was not designed to produce publication quality
    graphics. Fortunately, I've figured out how to improve things, if only a
    little bit. The scientific notation puzzle is worked out here:

    http://peltiertech.com/Excel/Charts/...cNotation.html

    So how's the weather up in Lewiston?

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______

    Bates Senior Thesis Researcher wrote:

    > Hi I'm using Excel 2003 and I am trying to make a column graph where the
    > y-axis represents bacterial growth in log form. Therefore, the numbers are
    > quite large. I need the axis to say "10^3" and not "1.E03". I am confused
    > as to why the only scientific notation that I can find is written as "1.E03"
    > because no scientific journal that I have come across uses this notation on a
    > graph. I have tried using the "custom" tool and adding "^3" to the end but
    > the number ends up being quite large and not anywhere what I need it to be.
    > Thank you.


  3. #3
    Bates Senior Thesis Researcher
    Guest

    Re: Scientific Notation when graphing

    Thanks for the info! I shall pass it on to my advisor. I find it
    interesting that a program designed by scientists and math people doesn't
    produce scientific notation that way, but I suppose it's a moot point.

    Lewiston is covered in several feet of snow. I predict it will remain on
    the ground until graduation in May...

    "Jon Peltier" wrote:

    > Unfortunately, Excel was not designed to produce publication quality
    > graphics. Fortunately, I've figured out how to improve things, if only a
    > little bit. The scientific notation puzzle is worked out here:
    >
    > http://peltiertech.com/Excel/Charts/...cNotation.html
    >
    > So how's the weather up in Lewiston?
    >
    > - Jon
    > -------
    > Jon Peltier, Microsoft Excel MVP
    > Peltier Technical Services
    > Tutorials and Custom Solutions
    > http://PeltierTech.com/
    > _______
    >
    > Bates Senior Thesis Researcher wrote:
    >
    > > Hi I'm using Excel 2003 and I am trying to make a column graph where the
    > > y-axis represents bacterial growth in log form. Therefore, the numbers are
    > > quite large. I need the axis to say "10^3" and not "1.E03". I am confused
    > > as to why the only scientific notation that I can find is written as "1.E03"
    > > because no scientific journal that I have come across uses this notation on a
    > > graph. I have tried using the "custom" tool and adding "^3" to the end but
    > > the number ends up being quite large and not anywhere what I need it to be.
    > > Thank you.

    >


  4. #4
    Michael R Middleton
    Guest

    Re: Scientific Notation when graphing

    You wrote: " ... a program designed by scientists and math people ... "

    Huh? Are you referring to Excel?

    - Mike

    "Bates Senior Thesis Researcher" <Bates Senior Thesis
    [email protected]> wrote in message
    news:[email protected]...
    > Thanks for the info! I shall pass it on to my advisor. I find it
    > interesting that a program designed by scientists and math people doesn't
    > produce scientific notation that way, but I suppose it's a moot point.
    >
    > Lewiston is covered in several feet of snow. I predict it will remain on
    > the ground until graduation in May...
    >
    > "Jon Peltier" wrote:
    >
    >> Unfortunately, Excel was not designed to produce publication quality
    >> graphics. Fortunately, I've figured out how to improve things, if only a
    >> little bit. The scientific notation puzzle is worked out here:
    >>
    >> http://peltiertech.com/Excel/Charts/...cNotation.html
    >>
    >> So how's the weather up in Lewiston?
    >>
    >> - Jon
    >> -------
    >> Jon Peltier, Microsoft Excel MVP
    >> Peltier Technical Services
    >> Tutorials and Custom Solutions
    >> http://PeltierTech.com/
    >> _______
    >>
    >> Bates Senior Thesis Researcher wrote:
    >>
    >> > Hi I'm using Excel 2003 and I am trying to make a column graph where
    >> > the
    >> > y-axis represents bacterial growth in log form. Therefore, the numbers
    >> > are
    >> > quite large. I need the axis to say "10^3" and not "1.E03". I am
    >> > confused
    >> > as to why the only scientific notation that I can find is written as
    >> > "1.E03"
    >> > because no scientific journal that I have come across uses this
    >> > notation on a
    >> > graph. I have tried using the "custom" tool and adding "^3" to the end
    >> > but
    >> > the number ends up being quite large and not anywhere what I need it to
    >> > be.
    >> > Thank you.

    >>




  5. #5
    Jon Peltier
    Guest

    Re: Scientific Notation when graphing

    Designed by geeks for accountants, but used and abused by all kinds of
    people.

    - Jon

    Michael R Middleton wrote:

    > You wrote: " ... a program designed by scientists and math people ... "
    >
    > Huh? Are you referring to Excel?
    >
    > - Mike
    >
    > "Bates Senior Thesis Researcher" <Bates Senior Thesis
    > [email protected]> wrote in message
    > news:[email protected]...
    >
    >>Thanks for the info! I shall pass it on to my advisor. I find it
    >>interesting that a program designed by scientists and math people doesn't
    >>produce scientific notation that way, but I suppose it's a moot point.
    >>
    >>Lewiston is covered in several feet of snow. I predict it will remain on
    >>the ground until graduation in May...
    >>
    >>"Jon Peltier" wrote:
    >>
    >>
    >>>Unfortunately, Excel was not designed to produce publication quality
    >>>graphics. Fortunately, I've figured out how to improve things, if only a
    >>>little bit. The scientific notation puzzle is worked out here:
    >>>
    >>> http://peltiertech.com/Excel/Charts/...cNotation.html
    >>>
    >>>So how's the weather up in Lewiston?
    >>>
    >>>- Jon
    >>>-------
    >>>Jon Peltier, Microsoft Excel MVP
    >>>Peltier Technical Services
    >>>Tutorials and Custom Solutions
    >>>http://PeltierTech.com/
    >>>_______
    >>>
    >>>Bates Senior Thesis Researcher wrote:
    >>>
    >>>
    >>>>Hi I'm using Excel 2003 and I am trying to make a column graph where
    >>>>the
    >>>>y-axis represents bacterial growth in log form. Therefore, the numbers
    >>>>are
    >>>>quite large. I need the axis to say "10^3" and not "1.E03". I am
    >>>>confused
    >>>>as to why the only scientific notation that I can find is written as
    >>>>"1.E03"
    >>>>because no scientific journal that I have come across uses this
    >>>>notation on a
    >>>>graph. I have tried using the "custom" tool and adding "^3" to the end
    >>>>but
    >>>>the number ends up being quite large and not anywhere what I need it to
    >>>>be.
    >>>>Thank you.
    >>>

    >
    >


  6. #6
    Jon Peltier
    Guest

    Re: Scientific Notation when graphing

    Both of my sisters graduated from Bates, and both graduations were on
    nice spring days. So there's hope...

    - Jon

    Bates Senior Thesis Researcher wrote:

    > Thanks for the info! I shall pass it on to my advisor. I find it
    > interesting that a program designed by scientists and math people doesn't
    > produce scientific notation that way, but I suppose it's a moot point.
    >
    > Lewiston is covered in several feet of snow. I predict it will remain on
    > the ground until graduation in May...
    >
    > "Jon Peltier" wrote:
    >
    >
    >>Unfortunately, Excel was not designed to produce publication quality
    >>graphics. Fortunately, I've figured out how to improve things, if only a
    >>little bit. The scientific notation puzzle is worked out here:
    >>
    >> http://peltiertech.com/Excel/Charts/...cNotation.html
    >>
    >>So how's the weather up in Lewiston?
    >>
    >>- Jon
    >>-------
    >>Jon Peltier, Microsoft Excel MVP
    >>Peltier Technical Services
    >>Tutorials and Custom Solutions
    >>http://PeltierTech.com/
    >>_______
    >>
    >>Bates Senior Thesis Researcher wrote:
    >>
    >>
    >>>Hi I'm using Excel 2003 and I am trying to make a column graph where the
    >>>y-axis represents bacterial growth in log form. Therefore, the numbers are
    >>>quite large. I need the axis to say "10^3" and not "1.E03". I am confused
    >>>as to why the only scientific notation that I can find is written as "1.E03"
    >>>because no scientific journal that I have come across uses this notation on a
    >>>graph. I have tried using the "custom" tool and adding "^3" to the end but
    >>>the number ends up being quite large and not anywhere what I need it to be.
    >>>Thank you.

    >>


  7. #7
    Tushar Mehta
    Guest

    Re: Scientific Notation when graphing

    Dunno who wrote XL in the first place but it sure wasn't scientists or
    mathematicians...or if they were they were awfully bad at their jobs.

    Things have improved in recent times but the program still has some
    ways to go.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <[email protected]>, =?Utf-
    8?B?QmF0ZXMgU2VuaW9yIFRoZXNpcyBSZXNlYXJjaGVy?= <Bates Senior Thesis
    [email protected]> says...
    > Thanks for the info! I shall pass it on to my advisor. I find it
    > interesting that a program designed by scientists and math people doesn't
    > produce scientific notation that way, but I suppose it's a moot point.
    >
    > Lewiston is covered in several feet of snow. I predict it will remain on
    > the ground until graduation in May...
    >
    > "Jon Peltier" wrote:
    >
    > > Unfortunately, Excel was not designed to produce publication quality
    > > graphics. Fortunately, I've figured out how to improve things, if only a
    > > little bit. The scientific notation puzzle is worked out here:
    > >
    > > http://peltiertech.com/Excel/Charts/...cNotation.html
    > >
    > > So how's the weather up in Lewiston?
    > >
    > > - Jon
    > > -------
    > > Jon Peltier, Microsoft Excel MVP
    > > Peltier Technical Services
    > > Tutorials and Custom Solutions
    > > http://PeltierTech.com/
    > > _______
    > >
    > > Bates Senior Thesis Researcher wrote:
    > >
    > > > Hi I'm using Excel 2003 and I am trying to make a column graph where the
    > > > y-axis represents bacterial growth in log form. Therefore, the numbers are
    > > > quite large. I need the axis to say "10^3" and not "1.E03". I am confused
    > > > as to why the only scientific notation that I can find is written as "1.E03"
    > > > because no scientific journal that I have come across uses this notation on a
    > > > graph. I have tried using the "custom" tool and adding "^3" to the end but
    > > > the number ends up being quite large and not anywhere what I need it to be.
    > > > Thank you.

    > >

    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1