Nonnumerical Axis in Excel Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
=================================
 
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
_______
 
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
 
Back
Top