category axis doesn't display values

L

Lorraine

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!
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Scatter chart with categories on x-Axis 2
One extra x axis item that wont go away - can anyone help? 3
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Positioning x axis at bottom of chart with negative values 5
Adding a line to a population bar chart 0
X Axis, Excel 2007 problem... 3
Display percent and value on stacked column chart 0

Top