Multiple Shading within a Scatter Chart

I'm working on a criteria matrix in Excel 2010 that automatically plots a single member in a Scatter Chart based on the two values. There are 4 suppliers listed in Column D starting in cell D4 thru D7. The "x" value is listed in Column E starting in cell E4 thru E7. The "y" value is listed in Column F starting in cell F4 thru F7.

The scatter chart will plot the points correctly, however, there are two issues:
1) If I try to insert a data label using the "Series Name," or in this case, the supplier's name, it will lists ALL of the suppliers Column D. It will not list the single supplier listed in cell D4.
2) The scatter chart appears with gridlines as a 4x4 matrix with a total of 16 cells. The "x" and "y" axis both start at 0 and go to 4. I can shade the entire chart one color. However, I want to shade some of the cells with darker and lighter shades.

Any thoughts on the two items listed above?

Hi Andy,

Thanks for the reply. Sorry for the delay, I went to DC for the weekend. Do you have instructions for "adding additional data series plotted as stacked columns"? Unfortunately, I'm not an Excel guru and I'm searching the web think I found the site, but it is not easy to follow.

Thanks,
Micah

Andy,

Thanks so much! Its been a busy week but I was able to figure it out! Thanks so much for all your help!

Micah

Andy,

Do you know how to insert a legend with space to the right of my charts? I know how to insert a legend to the right, but it still overlaps the chart. I even have the "Show legend without overlapping the chart" box checked but it still overlaps. I think its because my chart has a secondary axis. I cannot expand the size of the chart area without the entire chart expanding along with it.

Thoughts?

Micah

Andy,

Please see the attachment. I cannot figure out how to change the size to add space to the right so that the legend does not overlap. The XY Chart Labeler Add-In works great!

Thanks,
Micah

Thanks for all of the help, Andy. I really appreciate it. I'm nearing the end of these tasks. Mind if you help me with the attached bubble chart? It's driving me nuts!! Attached is a list of stakeholders and then they are being plotted in the bubble chart. However, they are not all being displayed. I inserted rows to add additional stakeholders but the series data will not capture. I try to reselect the range for the series data but then most of the stakeholders disappear. Thoughts?

Micah

Hey Andy,

I am so sorry to be asking you but I think that after this last request, I should be good to go. Please see the attached. I'm trying to insert the legend but where the legend will list the number and then the suppliers name associated with that number. From the both tabs within the attachment, you can see that Best Buy is #1, Sears is #2, and HH Gregg is #3. The legend wants to plot based on the data from the chart used to shade the scatter chart.

Thoughts? I really appreciate any assistance, Andy. Think I'll have to buy ya a few rounds the next time I'm in the UK!

Micah

Hey Andy,

Thanks so much for the reply. I created the bubble chart using the scatter chart you suggested! Thanks so much! Tomorrow I will attempt to "Define 3 series rather than 1 in order to have 3 legend entries instead of 1." I'm definitely not an expert at Excel so feel free to share a few steps on how I can do this. I'd really appreciate it. Being a financial analyst, there are just some technical things that I just have a hard time understanding. Thanks so much!

Micah