Nonnumerical Axis in Excel Charts

[Robert Agee]

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

 

[Daniel CHEN]

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
=================================

 

[Jon Peltier]

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]

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