Jon - I see where you went with this and I tried it by making a copy of
column A and removing the header. It then worked with a line chart but not
with the scatter chart. The scatter chart gave me values and I could change
the scale but I couldn't get it to give each value as listed in the data of
the new column A. (The data is not evenly dispersed, i.e., 31.5, 64, 192,
etc.)

Suzan

"Jon Peltier" wrote:

Suzan -

If you're making an XY Scatter chart, Excel automatically uses the first
column as the X values, and uses the rest of the columns for Y values
for one less series than you've selected columns.

If you're making a line chart, Excel usually uses each column of data as
Y values for another series, and uses counting numbers (1, 2, 3,..) for
the category values.

To help Excel realize what you want for a Line chart, put series names
in the top row, and leave the cell above the category labels blank:

Ser.1 Ser.2 Ser.3
10 120 130 145
20 125 140 135
30 135 145 140

I'm in the habit of doing this even for scatter charts. One of my few
good habits.

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


Suzan wrote:
The data is in three columns. My client wants the values in column 1 to also
be the x-axis values. Is this possible? Nothing that I have tried has worked.
Thanks in advance.

Suzan