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