View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Daniel CHEN
 
Posts: n/a
Default 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