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

Similar Articles

[PageSpeed] 1

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:

imap sent issue
Hello, Rule description: Apply this rule after I send the message through the IMAP account and on this machine only move a copy to a the Sent folder but it doesn't work... instead all of my messages ending up in "Sent Items" under my Personal Folders... why? John Smith <someone@microsoft.com> wrote: > Rule description: > Apply this rule after I send the message > through the IMAP account > and on this machine only > move a copy to a the Sent folder > > but it doesn't work... instead all of my messages ending up in "Sent > Items"...

Table Design Issue
I have a database the has a Parts Table and a Vendors Table. what needs to happen is i need a form that will allow someon to view all the information about that parts itself and the vendors that supply the part but every part is available by all 5 vendors for different cost, and i need to construct tables that when part information is undated or deleted it will reflect across the board and on the form itself be able to see the vendor name and the part information for that vendor. what type of relationships will be involved here Answered in tablesdbdesign. ...

Two network interface cards problem
Hi, In my machine,I have two network iterface cards.One for Internet,and the other for local area network.I want to bind the second card to send and receive data with UDP.I have try to use bind() function to bind its IP address,but failed because sometimes I can receive data.Who can help me,thanks in advance. bind() does not bind an IP address; it binds a port number, and "binding" means "publishes to the Internet as a connectable port number". There have been previous discussions of how to make a port available only on a particular network segment, but as far as I kn...

Address Labels
The situation: I work for a small business which has a large number of Excel wookboo files, each of which holds the details of a customer. Part of these details are - obviously - the name and address listin for that customer, with the name and each line of the address bein listed in seperate cells. The problem: The owner of the business has asked that I build up an Excel databas of every 2004-2005 customer (well over a thousand), which lists th name and address of each, in such a way that it can be printed directl onto sticky labels if necessary. Needless to say, trying to do this manua...

Outlook 2003 New Install Config Issues.
Hi, I've just had my PC reimaged and Outlook 2003 reinstalled. My PST file has been imported and my mail is where it sholud me. Problems is the veiws had changed from what i had before. For example, all folders now have gridlines between emails. I know how to remove these in customise view but is it possible to change the veiw for all folders at once or do i need to do each folder individually? Cheers, D "moox7" <moox7@hotmail.com> wrote in message news:28b14a58-eee6-46c2-ad29-909e710ed2dd@r37g2000prr.googlegroups.com... > For example, all folders now have gridli...

Pivot Table Report: Getting average of difference of two date columns
Hello I have data in excel sheet as: WORK_ID PROJECT START_DT END_DT 1001 P1 1/1/2006 1/10/2006 1002 P1 1/25/2006 2/20/2006 1003 P1 3/15/2006 3/20/2006 I want to have a report that will give me average time taken to finish a work in a project. That is, I have to take average of (end_dt - start_dt) for a project group. How do I do this in a pivot table report. When I use a calculate field to get the days worked for a work_id using DATEDIF(START_DT, END_DT, "D") then excel computes only sum on that (pivot table report ...

Bubble Graph where Both Axis are Categories
Hi there, I would like to use a bubble graph where the two axis are categories and not values. Only the size of the bubble will depend on values. Can anyone tell me how this works? Thanks for any hints! ...

Problem setting BackStyle on Label
I have a problem with Properties on Label in particular, when added by a script. The sequence below works on CommandButton1 and Frame1 objects but behaves strangely with Label1 Public Sub addLabel() Sheet2.OLEObjects.Add "Forms.Label.1", _ Left:=100, Top:=75, Height:=15, Width:=200 End Sub Public Sub nameLabel() Sheet2.Label1.Name = "title1" End Sub Public Sub setLabel() Sheet2.title1.BackStyle = 0 Sheet2.title1.Caption = "My Text" Sheet2.title1.Font.Bold = 1 Sheet2.title1.Font.Italic = 1 Sheet2.title1.Font.Size = 12 End Sub The one property that doesn&...

How do I place two or more charts on a worksheet?
I can't figure out how to keep Excel 2007 overlaying a new chart on top of an existing chart in a seperate worksheet. What I would like to do is create one 8.5 x 11 worksheet with four 3 x 5 charts on it. Select each chart and move it into position. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Rick@Draper" <Rick@Draper@discussions.microsoft.com> wrote in message news:082C5930-64F0-4A6E-958E-967BDCCDB9C9@microsoft.com... >I can't figure out how to keep Excel 20...

NET Client calling Axis web service
I have a Net 2.0 client (C# Winform) calling an Axis web service. I can authenticate, and send a request that is accepted and responded to, but I cannot see the response. The return for the call to the webservice is an object. Looking at the SOAP message that comes in, I can see the response. However when I assign the response to instance of the object, the result is null. Example: 1. WorkRequestServiceImplService myRequest = new WorkRequestServiceImplService(); 2. WorkRequestTO workRequest = new WorkRequestTO(); 3. WorkRequestStatusTO workRequestStatus = new WorkRequestStatusTO(); ...

Entering the same value into two table fields at the same time
Say that there is a table which has 2 fields (A, B) There is a form [Form1] (data entry type) to enter data for A by `TextBoxA`. There is also one more `TextBoxB` which is Not Visible. My target is to record the value of (entered thtough `TextBoxA`) into B field of the table as well. So I write down a code "Before Insert" of the Form1 that: " Form_Form1.TextBoxB = Form_Form1.TextBoxA " It is not recording A values into the field B... Where am I wrong? Can you help me please? Sory !!! When I write down the same code into `OnExit` of TextBoxA, it is working...!! yes, ...

Change Legend Entry label of "Total" to actual name of field.
I have two pivot charts. One has multiple criteria and when I create a pivot chart, each series field breaks out properly using the names provided in the multiple criteria given. Now, the issue is when I have a single (one) field name, the chart automatically has the legend entry of "Total" since I am using the 'sum of' option. I've manually changed the name of the field in the pivot table, but the label on the chart remains the same. I've go so far as to read several tips on going to the source data to change this but of course when working with pivot tables, you ca...

Two formulas in on cell based on two numbers in another cell?
Hi, Not sure this is possible but...I have a cell that has a number range in it and based on an amount in another cell want to calculate a new range. For example: Initial Range: A1 = 10 - 12 Calc Amount: A2 = 5 Final Range: A3 = 50 - 60 I think I can get the results by concatenating two formulas I'm just not sure how to enter the original numbers (A1) or how to distinguish between the two in the final formula (A3) Using Excel 2003. Hope this makes sense. Thanks. I would put the range in two different cells (eg A1 and B1). Then the multiplication is easy. If you ...

Outlook 2003 asks for password two times
Hi All, i am using Outlook 2003 and one IMAP account is configured. everytime i start outlook it asks for the password two times. it really irritates the users. do anyone have any idea of why it is doing that. Thanks Regards akshat wrote: > > i am using Outlook 2003 and one IMAP account is > configured. everytime i start outlook it asks for the > password two times. it really irritates the users. Oh good! Someone else with the same problem. I believe I posted a question, but no reply. Same situation - Outlook 2003, one IMAP account, and it asks me the password twi...

Registry issue
I've been developing a Service in VB.NET. I set the serivce up to run under the NETWORK_SERVICE account. I need to store several parameters for the service to load on start from the registry. I tried to create a new subkey in the service's ket that is created at install time, i.e., HKLM\SYSTEM\CurrentControlSet\Services\MyService. My idea was to create a subkey called Parameters (like the Windows Time service does) and store my data there. But I cannot even open that key - it always returns Nothing - then I get an error missing parameter if I try to create it. So I figure...

Weird Issues!
Hi All, I am facing a rather perculiar problem. I recently added and Exchange 2003 server to an existing 5.5 environment. I followed the checklisted install for the Exchange Server 2003 for a new installation into a Exchange 5.5 environment. Upon the completed installation and migration the Exchange 2003 server asked if I wanted to delete the connectors and I chose yes. I then removed the Exchange 5.5 server from the network. Now the Exchange 2003 server is sending and recieving internal mail just fine and also recieving External mail fine to all the clients......But it is not sending...

How do I take two pictures put them side by side to create one
I am trying to create one picture by placing 2 of them side by side. Use a photo editing program then insert the picture into Publisher. -- JoAnn Paules MVP Microsoft [Publisher] "coopskat679" <coopskat679@discussions.microsoft.com> wrote in message news:6EEB18D4-FB70-40AE-9CB6-AD40F8FD80A7@microsoft.com... >I am trying to create one picture by placing 2 of them side by side. coopskat679 wrote: > I am trying to create one picture by placing 2 of them side by side. Insert two pictures. Turn on the Snap to Objects option (Arrange > Snap > To Objects). ...

How do I change the scale of logrithmic curve on the x-axis?
I would like to reduce the x-axis range on a logrithmic curve from 10 to 50, but I am restricted to a scale of 10 to 100? A logarithmic scale by definition goes up in decades. You have to use multiples of 10, by this I mean 0.01, 0.1, 1, 10, 100, 1000 etc. You cannot use anything else -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25803 View this thread: http://www.excelforum.com/showthread.php?threadid=465768 It's true that Excel's chart engine i...

Joining two queries
Is there a way to join two queries together? In query 1, i have Invoice ID, Description, and Total In query 2, I have the same fields. I would like to see all the records from both queries. Please advise. "Tia" <Tia@discussions.microsoft.com> wrote in message news:D39EB571-0D64-4A8E-9107-351B10E1FE02@microsoft.com... > Is there a way to join two queries together? > In query 1, i have Invoice ID, Description, and Total > In query 2, I have the same fields. > > I would like to see all the records from both queries. Please advise. I believe what you're...

Bookmark Issue
Hi, I had this working perfectly a while ago, and I've made some change and now its not working. After my mainform went to the same record as my unbound subform, my subform would stay on its selected record. Now it goes way back to the 1st record, very annoying for a list thats 300 records long. Can anyone advise how to fix this? Cheers, Sub Form_Click() Dim rs As DAO.Recordset If Me.Parent.Dirty Then Me.Parent.Dirty = False End If 'Search in the clone set. Set rs = Me.RecordsetClone Set rs1 = Me.Parent...

Primary/Secondary Axis series count
Hi, I have a VBA function like so: Code: -------------------- Private Sub AddSeries(ByVal strName As String, ByVal rngValues As Range, ByVal rngValuesX As Range, ByVal xlAxis As XlAxisGroup) With Charts("Chart").SeriesCollection.NewSeries .AxisGroup = xlAxis .ChartType = xlLine .Name = strName .Values = rngValues .XValues = rngValuesX End With End Sub -------------------- Sometimes I add a series to the Primary Y axis and other times to the Secondary. How can I determine how many series are on the Primary and how many on the secondary????? Applicat...

how to switch the primary and secondary Y axis to opposite chart s
Using Excel 2007, evertyime I refresh pivot table data, my charts lose almost all of the formatting (ex. axis will disappear and chart type will revert from lines to columns). Most annoying problem I have when this happens is the primary Y axis moves from the left side to the right side of the chart, and when I re-introduce the secondary Y axis, it will appear on the left. How can I easily move the primary Y axis back to the left side of the chart or switch the two axes? I've tried choosing Layout - Axes to hide and re-display the axes but this did not work. Format the primary cate...

rounding issues
I have a simple formula to multiple a cell with another and subtract from another:=IF(K14<0,K14,IF(K17<K16,K14-K17*K15,K14-(K17*K15))) . I also have the cell set for currency and two decimals over. The calculations are automatically rounded up to the nearest $$. how can I keep that from happening? cheers Day First, unless you have the "Precision as displayed" checkbox checked in Tools/Options/Calculations, the value displayed has only a tenuous relationship to the value stored. So you should just be able to specify two decimals in the number format of your target ce...

Printing issue
Version: 2004 Operating System: Older version Arbitrarily whenever I print an Entourage message, the body of the message is now about quadruple line spaced. The message looks fine when I open it up but adds the line spacing when I go to print. A short 7 or 8 line message can now take 2-3 pages to print. Absolute waste of paper and can be very difficult to read! I didn't change any settings. This just 'happened'. But there must be something I can do to get it to print concisely. Thank you. ...

Control visability of Label on a report
I have a label box on a report that I have set as Visable=NO. However when a check box on the form generating the report is checked I want to change the visability of that label on the report to YES. Hope I said that clearly enough. Any help here will be appreciated. Thanks in advance Dave On Jun 7, 11:14 am, "Dave" <dave@accessdatapros> wrote: > I have a label box on a report that I have set as Visable=NO. > However when a check box on the form generating the report is checked I want > to change the visability of that label on the report to YES. > > Hope...