Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Nonnumerical Axis in Excel Charts
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 wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Nonnumerical Axis in Excel Charts
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/...tml#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 wrote in message ... 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Nonnumerical Axis in Excel Charts
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Putting Excel Charts into a Word document that's getting too big | Charts and Charting in Excel | |||
Print Excel charts in Word 2003 with fixed size | Charts and Charting in Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Pasting excel sheets with charts | Charts and Charting in Excel | |||
change axis info on radar charts | Charts and Charting in Excel |