Two issues with axis labeling

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|
+-------------------------------------------------------------------+



-- 
lumberzach
0
1/16/2012 8:29:26 PM
excel.charting 18370 articles. 0 followers. Follow

1 Replies
1380 Views

Similar Articles

[PageSpeed] 3

On Jan 17, 9:29=A0am, lumberzach <lumberzach.95a8...@excelbanter.com>
wrote:
> 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 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 |
> |Download:http://www.excelbanter.com/attachment.php?attachmentid=3D276|
> +-------------------------------------------------------------------+
>
> --
> lumberzach

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
0
1/28/2012 8:28:38 AM
Reply:

Similar Artilces:

CRM 4.0 queue issue
Hi, I've run into this in CRM 3.0 (and honestly, I don't know what I did to fix it). But now it's happening in CRM 4.0. I have a queue, and a user with an email address. I want all email that is sent to this user to also appear in the CRM queue. I have it working, it's just that I'm getting everything twice. Once as an email from the original sender, and once from the recipient to the recipient, with the original email as an attachment. For example, kbriscoe@domain.com sends an email to ITSupport@domain.com (Our queue's email address is ITSupport@domain.com). T...

creating labels
hi, how can i create labels so I can input about 100 names and they will print off in a label style, Ive tried everything please help!! -- \m/ O_O \m/ Laura..... :) Liverpool, England Laura, I would do a mail merge with word, For help on Word mail merge using Excel as the data source have a look here http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm http://www.mvps.org/dmcritchie/excel/mailmerg.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups s...

DNS Question
Hello All, I am working with a customer that has 2 Small Biz servers in the same office. These are on 2 domains, but the same subnet. I am having trouble getting mail to route between the 2 domains. Each is Small Biz server 2003. Domain A has a public IP of 72.151.19.122 and an internal IP of 192.168.200.78. Domain B has a public IP of 72.151.19.123 and an internal IP of 192.168.200.250. We are using a Netgear firewall and inbound and outbound mail between each of these domains and the rest of the world works fine. They just can't seem to talk to each other. I would think this woul...

How do I stop axis titles from overlapping with negative chart da.
The negative bar charts overlap with the category titles. I've tried offset, but it won't let me move the text more than '1000' units, and it still overlaps. Hi, You can find an explanation here. http://www.andypope.info/tips/tip002.htm Cheers Andy KarenNeedsHelp wrote: > The negative bar charts overlap with the category titles. I've tried offset, > but it won't let me move the text more than '1000' units, and it still > overlaps. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info Hi Karen - Double click on the category titles o...

enter-key works with two inputboxes but not with olny one.
Hi, There is a form with two inputboxes and a submit button.The focus is on the first inputbox. When the user presses the enter-key without having entered some text, the javascript message "wrong text" appears. This works. But if i remove the second inputbox, leaving only the first inputbox and the submit button, pressing the enter-key without any text does not show the javascript message. Nothing happens. The focus remains in the inputbox. You can see the page is postbacked, but that's all. Why does it work with two inputboxes and not with one? And how to fix...

Returning Data from a third cell in same row that meets two other
I'm looking for a formula that will return a result from a cell on a same row as two other cells that meet certain criteria. I'm sure there is a way to do this but i am a novice at this kind of stuff and can't seem to figure it out. For example i want a cell to = what is in column E when column A="36751" and when column B="Total Returns" The spreadsheet has 55000 rows. there will only be one instance where both these criteria are met. i want to use this to create a seperate spreadsheet with just info i need and can update on a daily basis. thanks in ...

Merge two excel files
I have two excel files with the same cell layout. Some of the entries in the first file are identical to the second file. How do I merge the two files so that the resulting file has no duplicates? Thanks in advance. Tom -- So long and thanks for all the fish! Tom, Copy the entries from the second file into the first, below the other entries (don't copy the header row). Then save the file under a new name. I'm going to assume that your data starts in cell A2, with headers in row 1, and extends down the page. In a column to the right of the data table, enter a formul...

Major instal issue
I have Money 2002 installed, and have had for some time. About two weeks ago, I started getting the Windows Installer "preparing to install" message repeatedly when I open Money, or when the Money Viewer is invoked in IE. Both Money and the viewer work fine, but no matter if I cancel or ignore the message, it keeps coming up roughly once every two seconds. The real issue though is this: since this started happening, I've been unable to install or uninstall anything else that uses the Windows installer (including trying to uninstall Money to solve the issue), as it fails saying t...

Comparing cell values then labeling them based on comparision
Hi. I'm trying to find a function or way to compare two cells and then label them according to if one cell is lesser, greater, or the same as the other. I have a large data sheet where I want to compare many pairs of cells and then have them labeled in this way. For example for each pair where the second cell value is larger than the first it would put greater, where the first is larger it would be lesser, etc. Can anybody help me with this? also feel free to email me at andrew@metiri.com. Thanks so much for your help. > Hi. I'm trying to find a function or way to compar...

Migrating from Novell to Windows 2000 server causes issues with .PST on Win95/98
All: Hopefully someone has seen this before and can provide a clue. We are currently migrating all of our user home directories from Novell 5 servers to Windows 2000 servers. The majority of our clients are XP and Windows 2000 workstations using Outlook 2000. However, there are still a number of clients using Windows 95/98 and Outlook 98. After copying .PST files from the Novell home directory to the Windows 2000 home directory using a Windows XP workstation, users using the Windows 95/98 workstations get an 'access denied error' when attempting to open their .PST folder from the ...

Two users on a network editing documents simultaneously in word 20
My office just upgraded from Word 2003 to Word 2007. We are on a network and share access to Word files. In Word 2003, if one user tried to open a file in which another user was working, a message would appear stating that the file was "locked for editing by (user)." It seems that with Word 2007, any user can open a file (and edit it) while another user is doing so as well. We do not want this to be the case, and just want the settings to be as they were with Word 2003 (i.e. if a document is in use, another user cannot access it simultaneously). Ideally, we'd lik...

Weird Vista screen issues
Hey, my screen is really weird. My screen is both used for my computer and for my Xbox 360. Now, today when I switched the screen cable from the Xbox to my PC my screen is really weird. Firstly, I cannot seem to choose 1680x1050 as a screen resolution, as whenever I choose it it says it has changed but there's still weird screen stuff with it. Icons and text on my computer are much more unsmooth and it's really starting to annoy my eyes. What's up with mah scr33nz? -- Tomatketchup Tomatketchup wrote: > Hey, my screen is really weird. My screen is both us...

Sumif with two criteria #2
I need to add column c if column a and column b both meet my criteria. example A B C 1 X Y 3 2 S Y 1 3 X Y 2 4 X F 3 5 F Y 3 X AND Y 5 On Thu, 30 Oct 2003 13:06:29 -0800, "danperez@joannstores.com" <anonymous@discussions.microsoft.com> wrote: >I need to add column c if column a and column b both meet >my criteria. > >example > A B C >1 X Y 3 >2 S Y 1 >3 X Y 2 >4 X F 3 >5 F ...

Exchange restore issue
Hi, We have an Exchange 2003 server that was previously being backed up via brick level with Arc Serve. Now it is being backed up with Veritas 10D. It was no longer being brick leveled just the IS. I have a user that deleted some recent folders out of her inbox and wanted them restored. I went through the process defined by veritas to complete the IS restore to the RSG. The restore shows complete but failed but there is a RSG MDBDATA directory with the priv.edb and stm files. I tired the run the eseutil /cc on the restore.env and that failed. Any idea's on how I can restore ...

Insert query with two left outer joins gives "Record is Deleted" m
Hi, I have built an insert query to combine data from 3 tables into one table based on a key value (RA_ID) on a form. Two of the from tables may or may not have data associated with the main from table. So I have coded the select from statement using left outer joins. When I run the query with a row in the first child table but not in the second it works fine but when I run the query with a key value that exists in the 2nd child table but not in the first I get a message saying "record is deleted". Anybody have any ideas what is causing this? Here is the query......... ...

File Sharing issues
We set up a tracking system using excel. We have 4 files we have shared so multiple users on the network can make live up to date changes. We have been having problems loading these files. It will pop up an error saying the file will close. All computers are running xp and have microsoft office 2002 on them. We have 4 files. 2 of these files are giving us most of the problems, and the 2 files that give us problems are usually used by one certian computer. Is there a connection issue with that computer that has caused these files to corrupt? I have researched as much as I can...

WIN 7 64Bit with HP CP2025dn LaserJet With Windows 7 64bit offline issue
I had a system crash which forced me to re-install windows. Now, my CP2025DN shows offline, I have to shut it off and turn it back on, as it's refusing to wake up from powersave in order to print, or if I log off, reboot and log back on, the printer prints my job. Can I just disable powersave or is there an option for always online? Thank you Tony Lisanti You should refer to the user manual about the settings for the printer. If you don't have the manual you can go to HP's website and download the documentation @ http://h20000.www2.hp.com/bizsupport...

Designing/Creating Zebra LP 2824 labels for RMS 2.0
Hi, I am trying to create a label to print on a Zebra LP 2824. I tried modifying the default Zebra label in RMS Labels folder with no luck. Also I downloaded a trial version of ZebraDesigner Pro. Tried to create a database connection since the field data is variable but it looks like the SQL server db now in RMS 2.0 is not supported with ZebraDesigner (I could not find the SQL file type *.mdf in the drop down menu - it works with Access, Excel, etc but apparently not SQL server). Any help/guidance with this is appreciated. Thanks Are you using the windows drivers for the zebra? ...

y axis on wrong side
Don't know how I did it, but the Y axis is on the right side of the chart instead of the left side. How to I get it to be on the left side of the chart? Thanks. -- Bill Double click on x axis, on Scale tab, change point at which y-axis crosses. Jerry Bill H. wrote: > Don't know how I did it, but the Y axis is on the right side of the chart > instead of the left side. > > How to I get it to be on the left side of the chart? > > Thanks. Bill, -- Just adding to Jerry's post -> another option might be to double click on x axis and on Scale tab look ...

Pop up resizing issues
My company recently installed Office 2007 on all computers. I have a database that includes some forms that are pop up controlled with set sizes. These worked fine in old version of access, but with 2007 the pop up form open as a small box (centered on the screen) but just not much bigger than the standard minimize/maximize/close buttons in the corner of each pop up. My forms were set to non-sizable borders (thin), so when these pop up small really nothing can be done for users of the database. Changing the borders to sizable is a temp fix, but i would really like the pop ups to ope...

Code 19 with Amex issued by Costco
I get an error : Code 19 when I swipe American Express cards that are issued by Costco. All others swipe fine. I can manually type the Costco cards, and they approve. Anyone else been down this road before ? Thanks for any help. Ed This is a multi-part message in MIME format. ------=_NextPart_000_06F2_01C71CC9.BD72F3A0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Ed, Check with your processor as the Costco card and others have a special = discount rate (higher) attached to them and you may not be able to = accept them. --=20 Jef...

Show Label & Text Box in Report based on Checkbox
Hi. I am attempting to show a label and textbox based on a checkbox in a report. The report is based on a SQL query joining two tables. The checkbox field is included in the query. Currently in the properties, I have the label and textbox .visible = false. I would like to set the label and textbox to visible when the checkbox response = Yes. I tried the OnLoad event of the form Private Sub Report_Load() If Checkbox = "Yes" Then Label.Visible = True Textbox.Visible = True End If End Sub This didn't work. Could someone help? I am unable to de...

Numeric Type: Issue
Hi! We are having an issue with our CRM installation. When the application is accessed from the client machines, the attributes with type 'Money' becomes blank on tab space after entering.It saves as blank. On accessing the same from the server machine itself, it doesn't give an problems. Help would be most appreciated Thanks a lot in advance. ...

Delegation issues in Outlook 2007
Hi There I have a PA who looks after a directors email mailbox and calendar, i have given this PA delegation access to the directors email account this is fine but when i add the mailbox into the PAs outlook client it adds the mailbox fine but we can't open it it comes up with the error: The set of folders cannot be opened. The information store could not be opened. We are using a Scalix enterprise mail server with scalix outlook connector -- Tom Burden IT Technical Support Analyst Specsavers Optical Group Delegation permissions in not the same as having access pe...

Exchange 2000 replication issue
I was told that I need to force an exchange replication, not sure what is meant by that, does anyone? My public folders seem to be fine, the issue is that the servers are not relaying email between themselves right now. They can recieve external email but cannot send it. I have since fixed it so that they can send email outbound, now the remaining issue is that the two servers seem not to be talking back and forth. Not sure what to check now. I figured out what they were talking about. In the Monitoring and Status area it was showing errors. An old IT guy we had just restrted the ...