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

Please Login or Register  to view this content.

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

Is there a way to get a representation like I pointed out, without knowing code?

Edit: Andy, just saw your spreadsheet - yes, this is what I was shooting for.

If you have a spare minute, could you type the process you took to get resolution on this? Would really appreciate it.

Originally Posted by Andy Pope

Using the Select data dialog.

I can't seem to find the right selections within the Select Data range to gather the information that I need.

Add new series, then select the cell for name, x value and y value.

X and Y value - this is where it gets messy. I have tried to use these when entering the select data ranges, in terms of convergence points. I get both points appearing seperately on the graph.

See inline.

Originally Posted by Andy Pope

1st chart, select range B2:C23, create a xy-scatter. Then use the addin to link series to range A2:A23

2nd chart, select an empty cell and insert and xy-scatter chart.
This should create a blank chart object. Use the select data dialog.
Add series, Select A2 for name, select B2 for X values, select C2 for Y values.
Repeat for next 22 rows. now you can see why I whipped up some code

Thanks Andy, testing now.

Success!

Andy - thanks for the insight. Much appreciated.

Cheers,

-Soloman

Originally Posted by Andy Pope

The first chart uses 1 series and links the data labels to column A
This free addin will help make those links.
http://www.appspro.com/Utilities/ChartLabeler.htm

The second is a series for each xy set.
I used code rather than manually pick each name, x and y cell.

This was super helpful.

Many thanks

Follow on question. How would I copy this macro to other worksheets?

Thanks

G