category axis doesn't display values

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

Guest

I have a very simple chart from a very simple 2 column spreadsheet. Y axis is
number of checks, X axis is SUPPOSED to be dollar amount. Instead of dollar
amount, I get sequential numbers (1,2,3, etc.). I did this type of chart a
hundred times in Excel prior to our upgrade to Office XP; can't do it now.
Help!
 
1. Did you make an XY chart? Line charts will not necessarily do what
you expect with the X axis.

2. Are the values in the X axis range numerical? Any non-numeric values
will mess up a line or an XY chart.

3. Is the chart even looking at the range with X values? Chart menu >
Source Data > Series tab, select a series, make sure the range is
selected in the X Values edit box.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top