ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Graphing powers of ten (https://www.excelbanter.com/charts-charting-excel/184481-graphing-powers-ten.html)

newfie

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.



Jon Peltier

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.





James Silverton[_2_]

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



All times are GMT +1. The time now is 12:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com