MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Logarithmic scale format

Posted by John on July 25, 2001 9:46 AM

I have a graph with a logarithmic scale. Is there a way to change the numbers from 1, 10, 100, 10000, etc. to exponential format (10superscript0, 10superscript1, 10superscript2)? All I'm finding is the 1.00E+02 format, which won't work. Thanks!

Posted by Mark W. on July 25, 2001 10:07 AM

There isn't an "exponential [number] format" --
only a Scientific format as you've already
discovered. Superscripting isn't a number
format, but rather a font formatting option
which can be applied character by character
for non-numeric value that reside in a
worksheet cell.