Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Graphing powers of ten

I want my graph to appear as 10^-1 and so on. Everytime I try to graph it, it
converts it to something else. Could someone help fix this problem.


  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Graphing powers of ten

Excel represents such numbers using this convention:

10^-1 = 0.1 = 1E-1
10^-3 = 0.001 = 1E-3
10^2 = 100 = 1E2

If you represent these numbers in a form Excel recognizes, do you have
better luck? If not, show us the numbers, and we'll take another swing at
it.

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


"newfie" wrote in message
...
I want my graph to appear as 10^-1 and so on. Everytime I try to graph it,
it
converts it to something else. Could someone help fix this problem.




  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 115
Default Graphing powers of ten

newfie wrote on Sun, 20 Apr 2008 17:11:00 -0700:

n I want my graph to appear as 10^-1 and so on. Everytime I
n try to graph it, it converts it to something else. Could
n someone help fix this problem.

Take a look at a logarithmic scale. I don't know exactly what
you want but that might help.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Graphing suz Excel Discussion (Misc queries) 1 April 1st 08 07:24 AM
How do I enter postccripts in an Exce, such as for powers of a nu Odiesdad Excel Worksheet Functions 2 January 31st 07 02:41 AM
graphing kckar Excel Discussion (Misc queries) 2 February 17th 06 08:51 AM
powers to negative numbers Dave.e Excel Worksheet Functions 6 February 10th 06 05:27 PM
graphing kristine Excel Discussion (Misc queries) 2 December 17th 05 05:12 AM


All times are GMT +1. The time now is 06:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"