Two issues with axis labeling

L

lumberzach

I have been having a few issues with getting my figure just right i
excel. My two main issues are as follows:

1. Is there a way to use scientific notation for all y-axis value
except zero? It just looks silly.

2. For my current figure the data points range from 440-700. I wa
wondering if it is possible to have the first tick mark start at 450 an
then proceed in increments of 50 for major tick marks and 25 for minor
I currently have the tick marks in the correct increments but they star
at 440 and end at 690. I would prefer to have the first tick mark 1
units to the right of the origin.


I attached a visual of the graph in question. I can always us
Kaleidagraph but I would prefer to just do it in excel since that'
where all the data is.

Any help is greatly appreciated

+-------------------------------------------------------------------
|Filename: Untitled-1.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=276
+-------------------------------------------------------------------
 
X

Xt

I have been having a few issues with getting my figure just right in
excel. My two main issues are as follows:

1. Is there a way to use scientific notation for all y-axis values
except zero? It just looks silly.

2. For my current figure the data points range from 440-700. I was
wondering if it is possible to have the first tick mark start at 450 and
then proceed in increments of 50 for major tick marks and 25 for minor.
I currently have the tick marks in the correct increments but they start
at 440 and end at 690. I would prefer to have the first tick mark 10
units to the right of the origin.

I attached a visual of the graph in question. I can always use
Kaleidagraph but I would prefer to just do it in excel since that's
where all the data is.

Any help is greatly appreciated!

+-------------------------------------------------------------------+
|Filename: Untitled-1.jpg                                          |
|Download:http://www.excelbanter.com/attachment.php?attachmentid=276|
+-------------------------------------------------------------------+

Here is how to do the first part. Format the axis - Number - Custom
- 0E+00;#;#,### - Add. This gives the formatting for
positive;negative;zero

For the second part, I'm not entirely sure what you mean but it looks
like Format the axis - Minimum Fixed 450 - Maximum Fixed 700 - Major
Unit Fixed 50 - Minor Unit Fixed 25 - Minor Tick Marks Outside.

This is 2007 but other versions should do the same. xt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top