HELP!! Scatter

I would say that this is "easy", but it is multi-faceted, so there are multiple steps along the way.

Your sample file does not include a basic scatter chart, but I will assume you know how to create a scatter chart.

To get the "conditional formatting" (color based on risk value), the most common strategy is to add each "color" to the chart as its own data series, and most of that effort is in the spreadsheet, not the chart. Tutorial here: http://peltiertech.com/conditional-f...-excel-charts/ The strategy described should easily adapt to a scatter chart.

I am not sure what you are trying to do with the "split into 4 quadrants" based on estimated opportunity. My first guess is that you want something like this: http://peltiertech.com/shaded-quadra...scatter-chart/

To get the ID# to display as the data label, add the data labels to each series, then "format" the data labels as "value from cells" (https://support.office.com/en-us/art...2-f467c9f4eb2d click on Add data labels for instructions on adding data labels and "change the look of data labels" to see how to change the content of the data labels.

Where do you get stuck?

What are you trying to do with this chart, because it does not seem to be doing any of what you described in the OP?

I notice that B3:C3 ("impact","effort") is being used as the horizontal X values. Since text does not mean anything in a scatter chart, Excel is using 1 for the first X value and 2 for the second x value. Your OP suggested that you wanted the impact values (B4:B12) to be the X values.

There are 9 data series in rows below for the Y values. The impact values are plotted above 1 and the effort values are plotted above 2. Your OP suggested that you wanted the effort values to be plotted as the Y values, so I would have expected the Y values for one data series to be C4:C12.

Assuming I am understanding what you want, you need to go into the Select Data dialog, clear the chart source data, then add a single data series that uses C4:C12 as the Y values and B4:B12 as the X values. 2010 help file, I expect 2013 is similar: https://support.office.com/en-us/art...angesourcedata

Am I understanding this correctly?