Yes, it's easy with simple arrays. But, I've got thousands of rows of data
and entering the range manually is not that easy. I experimented and found
solutions, but the new method is not as simple as the old program, although
it does offer some new features.

I found that if the data column label is included in the range than it
screws up the XY plot. I changed the range to only contain numbers and it
worked okay. The old system asked you if the first entry was a label or a
value; very handy.

Thanks.

"Shane Devenshire" wrote:

Hi,

What's in column A and C? And are you plotting column B also?

When I enter numbers in column A and C and then select the range A1:A12,
C1:C12 and choose Insert, Scatter, and pick Scatter with straight lines I get
exactly what I would expect.

Thanks,
Shane

"Mike M" wrote:

I'm trying to plot the values of Y (in column C) vs. the values of X (in
column A), but the chart plots the spreadsheet line number rather than the
column A value, even though the pop-up window shows column A is select for
the x-axis.

Also, it is now very difficult to select the data points in different
columns. It was easy before, by holding down the shift/control keys and using
the arrow keys.

I really hate the 2007 version! I was VERY proficient with XL before, and
now I am totally helpless trying to create some simple X-Y charts. The help
tools are totally worthless! Microsoft really screwed up a good product.