View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default (Visually Appealing) Scientific Notation on the Y-Axis

I have a solution (not yet on my website) that uses a free font which has
all digits in subscript and superscript
Send me a message (my private email not the newsgroup) so I can send you a
file
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"nima" wrote in message
...

Hi, I am new to these forums. I have really come to tap into the power
of excel during the past 1-2 years. As a research scientist, my latest
achievement is a spreadsheet that takes raw data and calculates
everything I need from simple mathimatical manipulation to statistical
analysis-and now, graphing. But, I am having a few problems:
the graphs I make are used in published results and large poster
displays-and, they're logarithmic along the Y-axis. I have a fairly
good understanding of number-formatting, but I can't figure out how (if
it is even possible) for me to make the y-axis numbers appear as
10<superscript6</superscript instead of '1.00 E+06'. I've tinkered
around with it, and the best i've gotten is '1 e6' using a custom
number format. Even if I have to do this manually per graph, fine-but I
can't even BEGIN to get this to work! BTW I'm using Bar Graphs. Also, I
have excel auto-graph a group of series that fill up as I assign them,
but is there a way to make excel exclude empty series?


--
nima
------------------------------------------------------------------------
nima's Profile:
http://www.excelforum.com/member.php...o&userid=30408
View this thread: http://www.excelforum.com/showthread...hreadid=500770