LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
nima
 
Posts: n/a
Default (Visually Appealing) Scientific Notation on the Y-Axis


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

 
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
Custom format for scientific notation Melinda New Users to Excel 2 December 22nd 05 03:57 PM
Using scientific notation in TEXT() function boopathi Excel Worksheet Functions 1 October 10th 05 08:23 PM
Disable Scientific Notation conversion Clark G. Excel Worksheet Functions 2 April 18th 05 05:35 PM
Removing Scientific Notation Trisha Lynn New Users to Excel 8 January 20th 05 06:38 PM
convert scientific notation to a number Peter Excel Discussion (Misc queries) 1 January 4th 05 07:08 PM


All times are GMT +1. The time now is 03:21 PM.

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

About Us

"It's about Microsoft Excel"