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
1236 Views

Similar Articles

[PageSpeed] 57

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:

synchiing two computers?
Is there a way to synch Outlook on two computers? I end up with some email on my laptop and some on my desktop - it would be nice if the two could be synched so that I could have all of my email on both computers. Take a look here, it may help: http://www.slipstick.com/outlook/sync.htm -- Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. After furious head scratching, Bill Andersen asked: | Is there a way to synch Outlook on two computers? | I end up with some...

Compare two cells in two different files and return answer
I am attempting to compare two text cells and if they both exist, I want to bring in a "yes" answer. If they don't, bring in a "no" answer. Here's an example of text. File 1 Col A Col B BRATTA ZPB_COMMON AHERNC ZPB_COMMON GENCABH ZPB_COMMON File 2 Col A Col B BRATTA ZPB_COMMON AHERNC ZPB_COMMON GENCABH So, what I want to do is say in File 1 take cells A1 and B1 compare them to File 2 and search Col A and Col B and if there is an exact mat...

Deleting issues
I'm using Outlook XP. Every time I try to delete an item, it tells me "Errors have been detected in the file ...outlook.pst. Quit all mail-enabled applications, then use the Inbox Repair Tool." So I go and use the Inbox Repair Tool, SCANPST. I scan outlook.pst, re-open Outlook, try to delete an item and get the same error message. Can someone help? How big is your .pst file? Can you create a new one and then drag and drop the items from the old to the new one? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (inser...

SBS 2003 RRAS/VPN issue
I've got a SBS 2k3 box, SP2. I believe it's Prem since I see SQL 2k5, but ISA isn't installed. The firewall in place is the NAT/firewall in RRAS for the internet interface. The internal server IP is 192.168.16.1. I can successfully establish a VPN connection remotely from an XP machine, and get an IP address. It looks to be from the DHCP range from the internal server (16.37 for example), dhcp enabled says no. It's PPTP. From there, I can't get on the internet, nor can I ping or access the server in any way shape or form. I am unsure if this used to w...

Pivot table for two different data variables
I have the following table Name type Cost overhead amy C1 23 12 bob C2 129 17 cat C2 36 45 doo C2 100 32 I owuld like to create a pivot table that looks similar to: the standard pivot table. (Please ignore type for now.) name Data Total amy Sum of overhead 200 Sum of cost 12 bob Sum of overhead 130 Sum of cost 23 cat Sum of overhead 90 Sum of cost 19 doo Sum of overhead 87 Sum of cost 34 Total Sum of overhead 507 Total Sum of cost 88 But with overall total (overhead + cost) for ...

COUNTIF (?) on two criteria
I have a spreadsheet that logs work activities and records team members' completion of project units. Column B records team member names. Column C has project unit status - 'pending', 'beta' or 'completed'. It's easy to set up a formula to count how many units are allocated to each team member - =COUNTIF(B1:B1000,"Joe"). But what I need to do is set up formulas to count how many units Joe has completed, or has pending or at beta, and this means assessing data in both columns - which COUNTIF won't do. This doesn't strike me as an especially...

Two IF Statements with two answers
In cell J9 I need a formula that would do the following: If G9="Yes" then F9, If G9="No" then -f9 Note: G9 has a drop down list with Yes, No answers. If there are no other alternatives that yes and no =IF(G9="Yes",F9,-F9) otherwise =IF(G9="Yes",F9,IF(G9="No",-F9,"") Regards, Peo Sjoblom "heater" wrote: > In cell J9 I need a formula that would do the following: > > If G9="Yes" then F9, If G9="No" then -f9 > > Note: G9 has a drop down list with Yes, No answers. > =IF(G9=&qu...

Two axis
Positioning the Vertical axes: I have a chart where there are two axes. The first implementation produced the two scales on the right side, one inside, the other outside the chart area. Unusual, but luckily it fits well the chart. I tried to duplicate the feat with another dataset (similar in structure) and did not even get the second scale to show right, left or center (data plotted with two different scales allright). Where is the info to control these functionalities? Tx, Pierre On Wed, 29 Oct 2003 17:48:13 +0100, pl.carry <pl.carry@wanadoo.fr> wrote= : > Positioning the Vertic...

plot two groups of numbers on one series of xy coordinates.
how to create a plot from separate x and y values. i.e. y values do not correspond to the same set of x values. example x1= 5, y1=10; x2= 8, y2=15 I can read your question 2 ways; A) you data looks like this x y 5 10 8 15 etc. Select the data and make an XY chart B) you have two sets of data x1 y1 5 10 10 12 17 15 21 20 and x2 y2 3 8 7 14 12 19 18 24 Make an XY chart of the first data series Select all the data (including headers) for second set, and use Copy Click the chart to activate it Use Edit | Paste Special .... indicate New Ser...

two variables
I have a query that asks for collcode, collcode2 and booth. On any given day an employee may be collcode or collcode2. I would like to know how many times a certain emp has been paired with another employee. So how do I ask if an employee has been collcode/collcode2 and who the other person was? I hope this question makes sense. Thanks for any help Query one: SELECT CollCode, CollCode2, Booth FROM YourTable UNION ALL SELECT CollCode2, CollCode, Booth FROM YourTable Query Two SELECT CollCode, CollCode2, Count(CollCode) AS TIMESPAIRED FROM QueryOne GROUP BY CollCode, CollCode2 IF y...

0 values further issue
Hi Guys I have used =IF(Original!C33="","",Original!C33) to avoid pulling 0 numbers across but I have come across a secondary problem where =IF(A33>0,VLOOKUP(A33,'New Labour Standards'!$B$6:$C$990,2,FALSE)," ") and other formula on the same row beggining with =IF(A33>0 are now displaying #n/a entries. I want these entries blank if a33 is blank Thanks Brian Change them to: =IF(OR(A33="",A33<=0),"",VLOOKUP(A33,'New Labour Standards'!$B$6:$C $990,2,FALSE)) Note that I have made it "" rather than " &q...

Shared Workbook Saving issue
Hello All - I am using Excel 2007 and have a shared workbook that is also password protected. One user of the workbook attempted to save changes and received an error message that reads: "Caution: You are attempting to save a shared workbook that is also protected with a password. Portions of the file, including the change history, will not be encrypted. To help ensure the security of your file, unshare the workbook or delete the change history from the document. Do you want to save this file?" I would like to keep this as a shared workbook, so I attempted to delete t...

Find two PCI instance but load Init() one time
Hi all, I'm developing a stream interface driver for my PCI device under WinCE 6.0 and this driver works very well currently. Now, I got a problem when testing two the same PCI devices with my stream driver. The registry can find two PCI instances (i.e. PCI\Instance\mydrv1, PCI\ Instance\mydrv2) but system only call my XXX_init() one time. Does anyone know what the problem is? The following information is my registry setting: ================================================================== [HKEY_LOCAL_MACHINE\Drivers\BuiltIn\PCI\Template\mydrv] "Dll"="myd...

Setting hover data labels to cells other than source data
Hi and thanks in advance, I need a macro or something that will show a data label for a data source point when clicked or moved over by a mouse. I also need this data label to reference a different source than the source data used in the plot. For example, I am graphing a yield curve in relation to duration, however, instead of showing the x (duration) and y (yield) with the data label, I would like it to show the name of the instrument. x = column a, y = column b, instrument name = column c, for example. I have already tried using the tashar mehta macro for hovering data labels but it...

Comparing two lists for matches
Hi, I am trying to do the following: There are two sets of supplier lists - A List and B List. I need to compare the two lists. Source A is my master. Source B is a subset of that but has contact information for all the suppliers. Hence, my goal is to retrieve the contact information from Source B and match it to the suppliers of Source A. The above can be easliy achieved using a vlookup funtion. But the problem is that some of the supplier names in the two lists are not exact matches. Hence, vlookup does not catch it. For instance, a supplier is listed as ABC Inc. in A list and as ABC, inc....

Issues with MS Outlook 2007
I've just installed MS Outlook 2007 as a part of the Office 07 package onto a new computer running Windows 7 64b Home Premium. It's a change for me going from Outlook 2003. I have a few questions if someone can answer them for me. 1. When I print a monthly calendar, only the first couple of words or say, 10 characters of an event's description is printed. And not all events on any date that has say, 2 or more events are printed out. What can I do to get Outlook to print all events that appear on any specific day? It used to work fine with Outlook 03. 2. I also use...

Data export issues from Quickbooks
Hi, We are trying to migrate from Quickbooks to Great Plains. We are looking at various options in trying to extract data out of Quickbooks. 1. One of the options is export out through reports. However while exporting out transactions, here if an entry involves multiple accounts (called as SPLIT in Quickbooks), these accounts dont print on the reports unless you drill down. Has anyone encountered this situation. Any feedback on export of data out of Quickbooks will be appreciated (whether using reports or without it). Your export/import will be difficult and time consuming working...

Two copies of all Mailboxes
Using my sbs2003 srver with exchange 2003 installed - I notice two copies of all users mail box in the list of mailboxes using outlook 2003 on the same server. When I try to close these I get an error syaing mail boxes in use. I cn not remove them. Can you tell me how to remove these so I have just on mail box visible per user? thx Kevin Cain Class TECHNOLOGY ...

Global Contacts List Issues.
Does anyone know how to synchronize the Global Address List with a users Contacts list? Any and all help would be appreciated. Thanks. Daryl http://www.slipstick.com/exs/portagal.htm might be helpful. "darylakagod" <darylakagod@discussions.microsoft.com> wrote in message news:0EAE59B3-7A70-46A6-8E19-93A533C7E1C1@microsoft.com... > Does anyone know how to synchronize the Global Address List with a users > Contacts list? Any and all help would be appreciated. Thanks. > > Daryl ...

Trouble viewing messages in Outlook 2003, possible security issue
We have an inbox that is shared by a lot of users, it isn't setup as the actaul email account in Outlook is is just and extra added mailbox the users can view. When one company sends email to this inbox we cannot see the messages. They are in there and show in the total number of unread messages, but I can't see the message. I have installed Outlook on a spare machine and set this mailbox up as the actual email acocunt and then I can see the messages. When I open them I notice is says "Please treat this message as private" at the top of the message. I think it is a combi...

Compare two lists of names
Can you compare two lists of names where one list is last name first and the other is first name last? try this formual: =RIGHT(TRIM(E2),LEN(E2)-FIND(" ",E2))&" "&TRIM(LEFT(TRIM(E2),FIND(" ",E2))) it will convert First name last name to last name, first name or Visa versa. then you can compare your lists. "ea" wrote: > Can you compare two lists of names where one list is last name first and the > other is first name last? ...

How do I create a chart on two axes with two lines and a bar
I am trying to compare two final stock prices to the average volume. So, teh left axes would have the numbers for the stock prices, and the right axes would have the volume. The two stock prices would be lines using the left, and the volume a bar using the right. I can do one line and one bar, but I can't figure out two lines. Can anyone help? Forget the built in custom types. It's better to build your own. Create your chart using all the data, to produce a chart with three line series all on the primary axis. Select the Volume series, and on the Chart menu, use Chart Type to ch...

Unanswered NonConsecutive X Axis
I posted this earlier and never got a response, so I have added some more detail and am reposting in hopes of solving my issue... I have a single column of data AJ11:AJ58 which contains a formula that results in OPEN or CLOSED. I need to reference this column in multiple formulas as well as in the X Axis of a chart. Not only do these values change, but they are also not necessarialy consecutive. For example, one pass results in a range of OPEN cells (which is what I need to reference) of AJ25:AJ52 and another common pass results in AJ11:AJ12,AJ21:AJ58. Is there a way to name this dy...

how do I display last two digits of a SSN in a separate column
I am trying to create a formula to take an existing list of 8 or 9 digit numbers and display the last two numbers in a separate column. Is this possible? Try =RIGHT(A1,2) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "katbone1" wrote: > I am trying to create a formula to take an existing list of 8 or 9 digit > numbers and display the last two numbers in a separate column. Is this > possible? Hi Use a formula =3Dright(A1, 2...

Issue debugging CLR procs through stuido 2008 running on windows s
I am unable to debug from our dev server to our database server. I receive a warning then an exception (indicated below). The proc does execute however I am unable to step into debug at all. I'm a domain admin on both boxes and the sql connection for the proc is using Integrated Security I'm not seeing anything of not in the event log on the SQL box, but I am seeing the below audit failure Does anyone have an idea of how to resolve this? Thanks Audit Failure -------------------------------------------------------------------------------- The domain contro...