Multivariable Scatter Plot

Hi all,

At a standstill with Excel 2007, trying to create a scatter plot for convergence data.

Essentially, I want (x,y) to be one point on the graph, while the title for the scatter plot point (a) is held in the legend (similar to how I was able to run this in Excel 2003). In essence:

a = scatter plot point title
x, y = scatter plot point

I have three columns.

Column One = a
Column Two = x
Column Three = y

How can I comport this into the aforementioned scatter plot graph?

Any help much appreciated,

Soloman

Legend	x	y
Application	Amount of Data*	Clients Impacted*

The 2003 version allowed you to manually input a different range for each variable.

The 2007 version only allows you paired ranges, and I am EXTREMELY frustrated! Is there a workaround?!

This is just silly.

Andy, thanks for the reply. I have fiddled with the set data options and cannot get the data to display as points of convergence.

Essentially, I would like "Application" to be on the legend, with "Amount of Data" and "Clients Impacted" (two seperate columns of data) to represent x, y convergence; i.e. a singular point. (For example: 3 Year Plan = 8.00, 8.75)

I've attached the sheet I'm working with, it's really simple data.

Any help greatly appreciated.

-Soloman