Custom X-axis

Hi everyone.

I need to create a custom x-axis in which the values 
double at each interval.

i.e. At the first interval the value must be 20, the next 
25, 31.5, 40, 50, 62 ...20,000. Even though the numbers do 
not have an similar differences (e.g. 25-20 is not equal 
to 62-5) I will still need these values to be equally 
spaced.

Thanks for any help you give, it's greatly appreciated!

Fred.

PS. If you want to know what I'm doing, I'm plotting an 
amplitude:frequency graph, where each spacing between each 
frequency is 1/3 of an octave.
0
8/22/2003 9:59:00 AM
excel.charting 18370 articles. 0 followers. Follow

4 Replies
1421 Views

Similar Articles

[PageSpeed] 22

Fred -

Two options.  Make a Line chart, or make yourself a custom axis 
according to these instructions (align it on the horizontal axis, not 
the vertical):

http://www.geocities.com/jonpeltier/Excel/Charts/ArbitraryAxis.html

or this:

http://www.geocities.com/jonpeltier/Excel/Zips/Livestock.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Fred wrote:
> Hi everyone.
> 
> I need to create a custom x-axis in which the values 
> double at each interval.
> 
> i.e. At the first interval the value must be 20, the next 
> 25, 31.5, 40, 50, 62 ...20,000. Even though the numbers do 
> not have an similar differences (e.g. 25-20 is not equal 
> to 62-5) I will still need these values to be equally 
> spaced.
> 
> Thanks for any help you give, it's greatly appreciated!
> 
> Fred.
> 
> PS. If you want to know what I'm doing, I'm plotting an 
> amplitude:frequency graph, where each spacing between each 
> frequency is 1/3 of an octave.

0
jonpeltier (303)
8/22/2003 1:15:35 PM
[This followup was posted to microsoft.public.excel.charting with an 
email copy to Fred.
Please use the newsgroup for further discussion.]

Well, you can always simulate the effect.

Create a series that has equidistant values for the x-values 
(1,2,3,4,etc.) and zero for all the y-values.  Plot this series.

In another column, for each point in this dummy series, enter the label 
you want (20. 25, 31.5, etc.)  Use Rob Bovey's XY Chartlabeler (free 
from www.appspro.com) to add this column as labels to the dummy series.

Remove the default x-axis formatting (double-click the axis, then in 
the resulting dialog box, in the Patterns tab, set the Tick Mark Labels 
to None).  Adjust other formatting as desired.

-- 
Trouble finding replies to your posts?  Use a newsreader.  See the 
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <08a201c36894$02c21c30$a601280a@phx.gbl>, 
thebarbarian@talk21.com says...
> Hi everyone.
> 
> I need to create a custom x-axis in which the values 
> double at each interval.
> 
> i.e. At the first interval the value must be 20, the next 
> 25, 31.5, 40, 50, 62 ...20,000. Even though the numbers do 
> not have an similar differences (e.g. 25-20 is not equal 
> to 62-5) I will still need these values to be equally 
> spaced.
> 
> Thanks for any help you give, it's greatly appreciated!
> 
> Fred.
> 
> PS. If you want to know what I'm doing, I'm plotting an 
> amplitude:frequency graph, where each spacing between each 
> frequency is 1/3 of an octave.
> 
0
ng_poster (159)
8/22/2003 1:41:45 PM

    
0
8/22/2003 1:41:46 PM
Fred wrote:
> Hi everyone.
>
> I need to create a custom x-axis in which the values
> double at each interval.
>
> i.e. At the first interval the value must be 20, the next
> 25, 31.5, 40, 50, 62 ...20,000. Even though the numbers do
> not have an similar differences (e.g. 25-20 is not equal
> to 62-5) I will still need these values to be equally
> spaced.
>
> Thanks for any help you give, it's greatly appreciated!
>
> Fred.
>
> PS. If you want to know what I'm doing, I'm plotting an
> amplitude:frequency graph, where each spacing between each
> frequency is 1/3 of an octave.

1/3 octave data should probably be plotted on a log scale.  I'd start with a
logarithmic x-axis.

Now if you need labels at 1/3 octave center frequency, you will probably
need to use a dummy series with labels.  Jon and Tushar gave you the details
on that one a few days ago, so I won't replicate their efforts.

Dave
dvt at psu dot edu


0
dvt (216)
8/25/2003 4:31:57 PM
Reply:

Similar Artilces:

RE: Excel data exported to custom Outlook form
Greetings earthlings, I have an issue that I have been trying to resolve for sometime, I think I will provide the scenario and hope someone has an answer. Here it is. - I have Excel workbook called "users.xls" - I have a worksheet called "location" - I have a cell B10 in the worksheet who's contents I want to be exported to a textbox called "state" in a custom Outlook form called "RFCO" that resides in the personal forms library in Outlook. (this custom form is from an email template) - I then want to be able to email the form. How do I c...

Customer Statement - Footer summary
-------------------------------------------------------------------------- 7/1/2005 11:34:00 AM CDT -- Stephanie Drilling Can you asssit with a report modification issue? (8248456) We are working on the User Defined Statement format. We have national accounts Cash is applied at the parent account level We wanted a statement that provides a detail of the items by child account with subtotal, then in the report footer, a summary of child account with balance. We can get everything but the footer to do what we want. I have enclosed screen prints and the package file of the report. Any i...

List output to a x by 10 range
I have a list that x lines long. I want to transpose that list to another range (starting on cell M1) that is 10 columns wide and however many rows long. I know this is super simple. Does it have something to do with range resizing? No doubt you've already experimented with macro recorder, discovering the standard transpose command wont wrap within a range. So we need handle the transposition manually. Presuming your data begins in cell A2: Sub test() For Each c In Range("A2", "A" & Range("A65536").End(xlUp).Row) Row = Row + 1 ...

How to transfer Autocorrect from Office X to 2004?
when i installed office 2004, none of my autocorrect entries moved over from office X so i am starting from scratch. how do i get my office X autocorrect entries into office 2004? On 12/18/07 9:33 PM, in article d27726ff-5e3f-4b60-ba4a-3f2ac7bf7340@r29g2000hsg.googlegroups.com, "irchamandy" <irchamandy@gmail.com> wrote: > when i installed office 2004, none of my autocorrect entries moved > over from office X so i am starting from scratch. how do i get my > office X autocorrect entries into office 2004? You should be able to drag the files to a text editor to open....

customized receipts
Hi all, I'm looking for full page customized receipts/invoices, I checked Business Solution Webpages but those did not work for me. All I need is lines seperating each column, or rectangular areas for each column. I do not know how to edit XML, if you know any source where I can download receipts/invoices, pls send me the links. tech@fampos.com We customize reports for a fee. Call if you are interested. 208-376-8121 "ProNY" wrote: > Hi all, > I'm looking for full page customized receipts/invoices, I checked Business > Solution Webpages but those did not work ...

Ping Jon Peltier: Custom colors above & below horizontal lines
Hello again, I was wondering if you had any suggestions on how to color-code "zones" within a chart. Using some the techniques described on your (EXTREMELY helpful!!) website, I have created a box-and-whisker plot, and added horizontal lines indicating certain target values (upper and lower). I would like to conditionally color-code the plot areas delineated by these upper and lower horizontal lines...i.e. below the 5th percentile line=red, above the 25th percentile line=green, between the 5th and 25th percentiles=yellow. Any thoughts, ideas, recommendations etc. would be greatly ap...

Word X text converter for WordPerfect (wpd) files
Is there a text converter available for Word X that converts WordPerfect (spd) files? In article <0b1e01c39a76$b3cad9e0$a001280a@phx.gbl>, "JPS" <anonymous@discussions.microsoft.com> wrote: > Is there a text converter available for Word X that converts WordPerfect > (spd) files? No. Check out Dataviz' MacLinkPlus: http://www.dataviz.com/products/maclinkplus/ ...

Email to a New Customer
We have just installed Exchange 2003 as part of SBS 2003 Premium. I can sucessfully send, but can't seem to get an email received by a customer who uses AOL. Exchange works fine with all other accounts I have tested. Here is a copy of the message being sent back: "This is an automatically generated Delivery Status Notification. THIS IS A WARNING MESSAGE ONLY. YOU DO NOT NEED TO RESEND YOUR MESSAGE. Delivery to the following recipients has been delayed." Any ideas of where to start? Thanks. In news:OGcz46HsFHA.912@TK2MSFTNGP11.phx.gbl, Jim L. <jim167(***)@pdq.net&...

Inserting Data into Custom Entities
We have created a custom entity in CRM. We would like to populate this data with data from another application. How can we accomplish this? Thanks, Amy Hi, If the data has to be imported one time then you can use Microsoft DMF or if you want real time data population then you can rely on integration tools like BizTalk or Scribe or you can write a console application in .Net which can retrieve the data from the application and use SDK to import the data into CRM. Hope this answers your query. -- Regards Ram "AAA" wrote: > We have created a custom entity in CRM. ...

isv.config rollback to default value when publish new customization
dear expert, Anybody had idea for this problem?? "msnews.microsoft.com" <hattha9@hotmail.com> wrote in message news:eSkdJp7UFHA.3312@TK2MSFTNGP09.phx.gbl... > dear expert, > Anybody had idea for this problem?? > > > Yes, there is another copy of the ISV.config that gets copied on public - cant remember where it is. A search will find it, rename it and all will be fine for the next publish. I will try and find the exact location and post The file should be located in the c:\Program Files\Microsoft CRM\Tools\Config, or wherever you installed M...

I am making a charts with weird X-values for my Ecology cl\
i am making a chart with weird X-values. Instead of single, whole numbers, I need each value to be as follows: 1-2, 3-5, 6-10, 11-15, etc. Please help me!! My chart keeps going to whole numbers instead and its been driving me crazy for days! What chart type are you using? If you want your X-axis to be category labels, rather than actual numbers, you may find that a line chart (or one of the other chart types) is more suitable than an XY (scatter) chart, if the latter is what you are currently trying. -- David Biddulph "Holly" <Holly@discussions.microsoft.com> wro...

IE 8,x How do I remove Ask.com Nero Toolbar.?
Operating System Windows XP SP3 ISP Earthlink.net Name: Nero Toolbar Publisher: Ask.com Type: Toolbar Version: 5.5.2.106 File date: Date last accessed: Today, March 09, 2010, 3 minutes ago Class ID: {D4027C7F-154A-4066-A1AD-4243D8127440} Use count: 16 Block count: 3 File: GenericAskToolbar.dll Folder: C:\Program Files\Ask.com Should I edit the registry and delete the class ID? {D4027C7F-154A-4066-A1AD-4243D8127440} -- ________ ...

Enter 8 x digit figure to return dd/mm/yyyy (with parenthess)
I would like to type a 8 x digit figure into a cell and on the strike of the enter key the 8 x digit figure would change from 12062004 to 12/06/2004, representing 12th day of June, year 2004. Thanks in advance :) Alan Bartley Sydney Australia Chip Pearson has some code that'll do what you want at: http://www.cpearson.com/excel/DateTimeEntry.htm Alan Bartley wrote: > > I would like to type a 8 x digit figure into a cell and on the strike > of the enter key the 8 x digit figure would change from 12062004 to > 12/06/2004, representing 12th day of June, year 2004. > >...

customize forms
After installing MS CRM, I customized a form (in this case a Lead Form). After I customized the form, my changes didn't appear on the standard input form (New Lead). Can anybody help me? Regards, Dick van Loo The only way I have found to do this is to Update the schema in deplyment manager and then do an IISRESET on the web server "Dick van Loo" <d.vanloo@in2info.nl> wrote in message news:0b5701c3572e$d8348aa0$a101280a@phx.gbl... > After installing MS CRM, I customized a form (in this case > a Lead Form). After I customized the form, my changes > didn't ...

custom filtering/migration of .msg file contact data to .vcf format
I need a way to filter and process incoming sales contact data (name, addres, phone, etc) within incoming .msg files (sample .msg message body below) and append directly to my Outlook Contacts file (.vcf output) for future use. I receive this info from web queries emailed to me, and I'm looking for a way to automatically process every message contact in a format below - the volume of email could be very large, so it needs to be automatically executed by an outlook rule (I can setup a rule to apply only to these emails, based on the subject text, which can be assumed to be unique). I'...

Custom baseline fields
Hello, I have created a custom table which includes extra cost columns for each task. I use these columns to direct enter material and travel costs. I then have another cost column which totals the labor ([COST] column and these other cost columns. I would like to save this subtotaled column as a baseline since it represents my total cost for that task. Is there any way to add additional fields to the original 9 baseline fields available? I can't seem to find a way to do this and it would be very helpful. Thanks No there isn't. You will need to manually c...

custom recipients #3
We are running exchange 5.5, a custom recipient I setup cannot recieve attachments fowarded to him. He can get them if they are loaded to a hard drive first and than attached to a new message. I called his ISP, they do no filtering. I can foward messages with attachments from my own pop3 account to him. Any help would be GREAT. -- Joed "Joed" <Joed@discussions.microsoft.com> wrote: >We are running exchange 5.5, a custom recipient I setup cannot recieve >attachments fowarded to him. He can get them if they are loaded to a hard >drive first and than attached to...

how to create custom calendar?
Hi Anyone know if it's possible to create a customer Outlook 2003 Calendar? (for use in the public folders) Like, we want written on our public shared calendar, "Welcome to our team!" etc. Is this possible? Thank you! you could use a folder home page... or name the folder ' welcome to our team' :) -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook Tips: http://www.outlook-tips.net/ Outlook &...

Setting Chart X and Y values indirectly
I would like to set X-Values in my chart in a cell of a worksheet, so that when the range of my x-values changes I will not have to go into the wizard and type it again. For example, I want to use the following X-values in my chart: =DATA!$I$2:$I$20 But instead of typing the above in the X Values: field in the 'Source Data / Series' wizard, I would like to type it, say, in cell $A$1 of 'Sheet1', and then type in the X Values field in the 'Source Data / Series' wizard the following: =Sheet1!$A$1 I tried it and it does not work. Can you please let me know if th...

Resolves a custom entity
Is there a way to create a resolution message just like one for any system entity, for example case resolution? I have created an custom entity but struggling with a way for the users to close and resolve the custom entity. Thanks for your help. You can add a custom ISV button to your custom entity form that launches a page in a web dialog and sets the parent entity's status to inactive. On my blog I have a link to a step-by-step guide on cloning a record. Look at the code, and you will see how you can achieve this using a similar custom application. http://icu-mscrm.blogspot.com/...

Customization 06-23-06
Hi, I have a CRM 1.2 version, i need make some modifications: 1. Sum 2 fields(textbox's) and show in another textbox in the oportunnity form. 2. change textbox field "Probability" in Read-only status. How i do this???? Please, help me... a friend said, "create a Calculated fields", How i do this?? or what is the real solution for this problem?? CRM 1.2 only supported client side code for the onchange event in picklists. You could sum the two fields behind the scenes using a callout. ======================= John O'Donnell Microsoft CRM MVP http://codegallery....

How to set custom class name for MFC frame window?
When you create a frame window in MFC using following code: BOOL CMainFrame::PreCreateWindow(CREATESTRUCT& cs) { if( !CMDIFrameWnd::PreCreateWindow(cs) ) return FALSE; // TODO: Modify the Window class or styles here by modifying // the CREATESTRUCT cs cs.lpszClass = AfxRegisterWndClass(0); return TRUE; } In Spy++, the default frame name is Afx:00400000:0. How can I set custom name instead of the default name? Thanks. Michael On Wed, 16 Nov 2005 14:49:47 -0800, "Michael" <Michael@discussions.microsoft.com> wrote: >When you create a frame window in MFC usi...

Find oldest warranty ExpDate(s) for each customer
I have a tblWarranties containing multiple entries for each customer. I would like to return a record set of only the oldest ExpDate(s) for each customer. It is possible that a customer would have multiple warranties with the same ExpDate, so I would want all. So it would need to ignore the customers warranty records with ExpDates older then the most current ExpDate. For instance, in the example below only the last two entries would be part of the record set. WarrantyType Term BeginDate ExpDate Original Warranty 2 09-01-01 09-30-03 Parts...

Auto-wrap titles on horizontal axis??
I have 27 identically sized charts that I created in Excel 2007. All but 2 of them auto-wrapped the x-axis titles correctly. On the two bad charts the titles overrun each other. How the heck can I get these 2 misfits to conform? I can't find the setting on the Format Axis options and the Wrap Text button (under Home Alignment) is grayed out. As far as I can see, there is no difference in any chart settings between the good charts and the bad one. Nevermind...I fixed it myself. Weird. It's just seems to be a sizing issue. I may need to enlarge the rest of the charts or play aro...

Port DLL to OS X?
I have a .DLL. I need to port this to OS X (which I believe uses GCC). What is the equivelent of a .DLL under OS X? Assuming that the DLL uses standard ANSI C++, are there any pitfalls that I should be aware of when porting? Joseph, First of all, good luck :-) DLL:s are called dynamic libraries, dylibs, dynlibs or dynalibs on OS X. ANSI C++ will probably be fine, but you'll of course have to experiment. If the library is outputting some kind of data that should be accessible from OS X-applications, you should be aware that the file handling is completely different in the Mac-...