Nonnumerical Axis in Excel Charts

Hello,

Essentially, when plotting a series of Acid/Base ratios in cells with text 
formatting (ex. "0/100", "10/90", etc.") (X-axis) versus temperature change 
per ratio (Y-axis), Excel charts the actual row numbers (ex. 1, 2, 3, etc.) 
for the X-axis instead of "0/100", "10/90", etc.  Fraction and Number 
formatting of the ratio cells does not change this either.  Thank you.

Robert Agee
Purdue University
0
Agee (1)
3/19/2006 9:21:27 PM
excel.charting 18370 articles. 0 followers. Follow

3 Replies
627 Views

Similar Articles

[PageSpeed] 2

It depends which chart type you use.
If you use column chart type, the X axis should be your lables (10/90, etc.) 
not row numbers.
If you use X-Y charts, most likely you will get numbers as your X-axis.
If possible, please email me your file so I can do it for you.


-- 
Best regards,
       ---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
 - - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
=================================



"Robert Agee" <Robert Agee@discussions.microsoft.com> wrote in message 
news:19051580-E18B-4F11-8D60-C696948BE864@microsoft.com...
> Hello,
>
> Essentially, when plotting a series of Acid/Base ratios in cells with text
> formatting (ex. "0/100", "10/90", etc.") (X-axis) versus temperature 
> change
> per ratio (Y-axis), Excel charts the actual row numbers (ex. 1, 2, 3, 
> etc.)
> for the X-axis instead of "0/100", "10/90", etc.  Fraction and Number
> formatting of the ratio cells does not change this either.  Thank you.
>
> Robert Agee
> Purdue University 


0
3/20/2006 5:09:49 PM
If you have nonnumerical data in the X value range, an XY chart will use 1, 
2, 3 for the X values. If you convert the labels to values, and use an 
appropriate number format, you may be able to achieve what you need. 
(Applying number formats to text will not help.) Use =0/100, =10/90, etc in 
the cells; I'm not sure what to use for a number format, since the 
denominator is changing.

If you have to fake the labels, try this:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

or any of these:

http://peltiertech.com/Excel/Charts/ChartIndex.html#AxisScales

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions - 
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Robert Agee" <Robert Agee@discussions.microsoft.com> wrote in message 
news:19051580-E18B-4F11-8D60-C696948BE864@microsoft.com...
> Hello,
>
> Essentially, when plotting a series of Acid/Base ratios in cells with text
> formatting (ex. "0/100", "10/90", etc.") (X-axis) versus temperature 
> change
> per ratio (Y-axis), Excel charts the actual row numbers (ex. 1, 2, 3, 
> etc.)
> for the X-axis instead of "0/100", "10/90", etc.  Fraction and Number
> formatting of the ratio cells does not change this either.  Thank you.
>
> Robert Agee
> Purdue University 


0
jonxlmvpNO (4558)
3/20/2006 11:56:23 PM
I had to plot the data on an XY scatter plot graph.  However, a friend of 
mine said he completed it by using a line graph, then removing the line.  In 
that way I was able to have the axis labels as I wanted them.  Thanks to Jon 
an dDaniel for replying.  I hope it gives insight to anyone else with similar 
problems

Robert Agee
Purdue University
0
3/21/2006 1:14:30 AM
Reply:

Similar Artilces:

Excel 2003
When I click on the end of a formula in a cell, I usually get all the associated cells highlighted with different coloured borders. I have one workbook with several sheets where this no longer happens on just one sheet. Is there some option I need to turn on in the sheet to make the coloured cell borders appear? Or might it be something to do with very recently using automaic update to bring my Office 2003 up to date? Any assistance much appreciated. Tom Walker You should always get *exactly* the same actions if you would click in the formula bar. As far as having the cell itself h...

How do I search for data in excel?
I need to create either a macro or a function to do a search through out the entire spread sheet for data. Can you tell me how? In xl2k, you can group the sheets before you do edit|find. (Click on the first and ctrl-click on subsequent--or right click on a worksheet tab and choose select all sheets). In xl2002+, you can specify "within workbook" under the options button on the find dialog. In all versions, you could use Jan Karel Pieterse's FlexFind: http://www.bmsltd.ie/MVP/ Mikeal wrote: > > I need to create either a macro or a function to do a search through out ...

Excel getting info from Access
I have recorded this macro that modifies the information that I am pulling into Excel from an Access query. About half way down, there is a line that says, "WHERE (invexcption.Area='US006')". I know that I can modify the code to bring back another areas information. for example, invexcption.Area='US007'. I would like to be able to make the Area a variable, so that I can create and save a different file for each area... but cannot seem to get it to work. Does anyone have any thoughts? With ActiveWorkbook.Connections("Query from MS Access Da...

Formula for nonnumeric percentage
I have a spreadsheet that contains employee information. I have 1 column that states the sex (M or F). Now I want to know using a formula, what is the percentage of female employees. Thanks, Taleen Thanks!! It worked perfectly. Taleen >-----Original Message----- >If E1 to E9 contained the M/F's >=COUNTIF(E1:E9,"F")/COUNTA(E1:E9) > >Format the cell as percentage > >Dan E > >"Taleen" <tvarsam@yahoo.com> wrote in message news:044b01c36829$3105d700$a401280a@phx.gbl... >> I have a spreadsheet that contains employee informatio...

Excel vs Access
I have a project that I am being asked to develop for work. It will be a method to QA reports using a grading method for sections within the report. Initially, I was leaning towards using EXCEL with a userform to provide the input for the grading of the report. As I thought more about it, I realize that I can have around 1000 reports per year per person that will be QA'd. I was going to have a workbook for each employee. I am now wondering if ACCESS will be better suited do to the number of reports and use Excel for the boss to collect a summary of the data from Access...

Minimum and maximum value of Axis set by user by reference to form
Excel seems to have 2 alternatives for defining the min/ max value of an axis: either automatically or preset by the user. But is there any way that the minimum and maximum value that the axis is defined by the user based on the values of the spreadsheet (i.e., halfway between the above two apparent options provided by microsoft)? Yes, you can tie axis values to worksheet cells via a macro. The process is described via the link below . . . http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html -- John Mansfield http://cellmatrix.net "jonny" wrote: > Excel se...

Value Axis Adjustment
I created a Gnatt Chart with 8 activities. The times on the values axis are listed as 3:50 AM, 4:19 AM, 5:16 AM, 6:14 AM, 6:43 AM, 7:12 AM, 7:40 AM, 8:09 AM, 8:38 AM, however since my activities take place between 5:30 AM and 8:15 AM, I wanted to decrease the time that is displayed on the chart dramatically. For example, I would like to see the time on the values axis displayed in 5, 10, or 15 minute increments. I am assuming this requires me to adjust the minimum, maximum, major unit, minor unit, and category X axis data in the Format Axis, but I am not sure what to enter. Could yo...

Save excel automatically
Is there anyway to save a backup of excel automatically when you are working. I am using excel 97 and excel 2002 Thanks. ...

how do I extend a trendline to cut x & y axis in excel
How do I extend a trendline on a scatter graph in the chart feature of excel so it cuts the x and y axis Thanks very much Left-click on the trendline and choose Format Trendline. On the Options tab are parameters to extend ("Forecast") the trendline as far forward or backward as you wish. Jerry "msterling" wrote: > How do I extend a trendline on a scatter graph in the chart feature of excel > so it cuts the x and y axis > Thanks very much > ...

Excel Cell Width
How do I adjust the width of a cell WITHOUT adjust the entire column? You can't Regards, Peo Sjoblom "JeffW" wrote: > How do I adjust the width of a cell WITHOUT adjust the entire column? Jeff, the only way would be to use format center across selection, or merge cells to put two or more cells in the row together -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "JeffW" <JeffW@discussions.microsoft.co...

Excel VBA programming
I am bringing a large amount of data into worksheet 4 in a workbook. I want to use VBA to run queries on the table in worksheet 4. I am not sure how to set up a query for data that is in the same workbook. I'm sure this can be done, can't it? EggHeadCafe - Software Developer Portal of Choice Caching Pages and Application Data with Database Dependencies http://www.eggheadcafe.com/tutorials/aspnet/f3c54d02-702d-44df-9bd5-4a8530bde25f/caching-pages-and-applica.aspx Sure, but you will have to tell us more. the macro recorder can be your friend. -- Don Guillett Microsoft MVP Exce...

Secondary Axis #9
I am trying to creat a chart with one y axis as x and a secondary axis as 100-x. Is there a way to do that? When I add a secondary axis Excel picks the values for that axis I want to pick the values. Thanks JMH Format the axis and you can set the scales. -- David Biddulph "JMH" <JMH@discussions.microsoft.com> wrote in message news:D60F6E05-E272-4DA8-9552-0B4C76DC1B08@microsoft.com... >I am trying to creat a chart with one y axis as x and a secondary axis as > 100-x. Is there a way to do that? When I add a secondary axis Excel > picks > the values for that...

Limitation in number of charts
A friend of mine has run into a problem when adding charts to a workbook. Right now he has about 60 charts in the workbook, and when he tries to add another one, he gets in error telling him, that he exceeds "the maiximum munber of FONTS in a workbook". He has enough memory so that is not the problem, and as far as I have been able to find, that is the only limitation concerning the number of charts (btw he needs about 350 charts in the workbook). The only other linitations I have found deals with limitations for a single chart. Does anyone know if the details in different charts a...

stock chart non-linear y-axis
A chart displays columns representing #shares traded for a group of 20 stocks along x-axis. Because the displayed values span a wide range (some columns are 1000x larger than others) the small volume stocks are hardly visible. What is needed is a way to make Y-axis non-linera; however, a log scale is useless because of the enourmous compression that takes place at the higher end of the y-axis. Is there a way of displyaing non-linear values at a scale less than allowed by log values? Web-based stock charts do this regularly, for example see chart displayed on Yahoo finance of Apple Computers ...

Excel 2003 VB referencing #N/A not working but works in Excel 2007
I have a very simple macro that works in Excel 2007 but hangs up constantly in Excel 2003. Does anyone have a work around? Problem: When referencing cells that have a #N/A value, Excel 2003 craps out even if I use the ISNA application function before it. The following 2 statements will cause Excel 2003 VB to stop regardless of order if the cell that is referenced comes up with #N/A. Series = Cells(RowNumStart + X - 1, SeriesCol).Value If WorksheetFunction.IsNA(Cells(RowNumStart + X - 1, ColNum)) Then Further background.... I am actually wanting to find #...

Editing secondary x-axis
I have successfully created a secondary x-axis in Excel 2003, but cannot edit it. The dataset I want clearly sits on a second, upper (?) axis, but I cannot change min/max values, tick-marks etc as the only options available (using Format Axis) are for the primary axis. JM What kind of data is plotted on the secondary X axis? If it's in the form of a line or column chart, the axis will not be numeric and you will be unable to change the scale. Did you really create a secondary X axis? If you simply assign a series to the secondary axis, Excel often only creates the secondary Y ax...

Excel creating 'backup' version of my sheet...
Hi, a user noticed that one of his sheets is creating backup-copies by itself... - He deletes the backup version - opens the original sheet - change something - saves the original sheet - closes the original sheet tadaaaaa.... now a new file with 'name backup.xls' is created... He told me that he noticed this behaviour when he was 'protecting' his sheet by a password. Now we moved to Office2007 and he wants to get rid of this behaviour. Any suggestions? (btw, no add-ins are installed!) FOUND, Seems there is an extra checkbox, hidden in the tools options in 'Save...

how do I create GST worksheet in excel
What is a GST worksheet? Please explain what you're trying to do -- Kind regards, Niek Otten "jl" <jl@discussions.microsoft.com> wrote in message news:B3DAF564-FF76-40CC-BB14-E7C613D056F9@microsoft.com... > Hi jl, Sounds like Goods and Services Tax. Are you Australian? GST is calculated as 10% of sales. So if you quote a price inclusive of GST, the GST is =price/11 As in; Total Price $110 Includes $10 GST So, what do you want the worksheet to do? Ed Ferrero http://edferrero.m6.net/ Hi Ed, Thanks for your response. I am Canadi...

Excel auto accumulation formulas
Hi hello, I need a formula for auto accumulation formula like example: John need to give me USD50 everyday for one month, so if he never paid the money i will key in 0.00 in that collumn and the ammount accmulated for today is 50.00 and the next day calculation like USD100, but if he did the payment full i will key in 50.00, if he only pays USD30 i will key in 30.00, so the balanse out standing will shows 30.00 for today and will shows 80.00 on the next day. I need a formula for every single day it auto accumulate USD50. I'm trying alot of formula but none is working. Th...

Excel formula #5
I have downloaded data from my manufacturing system in a tab-delimited format. I import into excel and some of the data in some of the columns have quotation marks around my text. What formula can I write to detect whether there is a quotation mark at the begining or end of my column and if there is, delete the mark. Bear in mind that the data is different lengths. Thanks ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ Select the data and Edit>Replace>~?>...

Excel Changes not saving
Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel Hello, <br><br>I am working with a graph that is automatically updated through functions when I add new data to the spreadsheet. Everytime I try to change the format of the graph, (for instance making the values of the graph show vertically), when closing the spreadsheet after saving and opening the file again, the graph reverts back to its original format. Insight to my problem will be much appreciated! > This message is in MIME format. Since your mail reader does not understand this format, some or ...

how to delete duplicated entries from an excel list
how to delete duplicated entries from an excel list Chip Pearson has tons of ways of working with duplicates at: http://www.cpearson.com/excel/duplicat.htm stewart wrote: > > how to delete duplicated entries from an excel list -- Dave Peterson Use the technique here to tag the dupes, then autofilter on the tag and delete the filtered rows http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates "stewart" wrote: > how to delete duplicated entries from an excel list ...

Y Axis Scale Problem
Hello. I'm making a chart that shows me the times between entries in another worksheet. Thusfar everything works find but I noticed that there is the occational drought of entries and the time goes from averaging around fifteen minutes to a couple of hours. Especially during lunch. Is there a way I can get the Y axis to increase the Major unit the higher in the scale a point is. Something where I can have on hour take up half the total Y axis and the second hour take up another half or third and so on so I can put a nine hour workday on the scale and still have everything look ...

Excel 2003: Cannot access directory
I have a second hard drive where I store my files. The windows mapping originally mapped it as drive "F". I have added a 2nd DVD burner recently and now my second hard drive is mapped to "G". In my Excel 2003, under Tools:Options, when I click the Save tab, it gives me an error "Cannot access directory F:\data\excel". In fact, it happens when I click any of the tabs. Since this is where I need to change the mapping I am stuck. Anyone know how to change this outside of the application? -- Thanks, Jim "HeartInNC" <HeartInNC@discussions.m...

money to excel
Is there a way to get a downloaded money file from a bank which is in QIF or OFX from money into an excel file? ...