Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom format for scientific notation | New Users to Excel | |||
Using scientific notation in TEXT() function | Excel Worksheet Functions | |||
Disable Scientific Notation conversion | Excel Worksheet Functions | |||
Removing Scientific Notation | New Users to Excel | |||
convert scientific notation to a number | Excel Discussion (Misc queries) |