Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I've been at it for over 2 hours now and am just a bit flustered :)

I have the following data (for example):

Label | Criterion 1 | Criterion 2 |
  A1  |      7      |      3      |
  A2  |      1      |      6      |
  S1  |      7      |      7      |
  S2  |      1      |      1      |

All I wish to see is a scatter plot with Criterion 1 and 2 as the X and Y axes and the 'label' elements as values on the graph (i.e. each 'dot' on the graph is labeled as whether it belongs to A1 or A2 or S1 or S2). Basically the items under the label column being shown as a legend. So it looks like this:

  A
C |
r |
i |                            Legend
t | ^      +                   ^ A1
e |                            + A2
r |                            # S1
i | *                          * S2 
o |      #
n |
2 |
  +-------------------->
       Criterion 1   

I'm sure this is NOT rocket science but I'm getting the most weird graphs imaginable if I just select all 3 columns (label, criterion 1 and 2) and ask for scatter plot. I've tried playing around with everything and for some reason the scatter plot just doesn't show up the way I want it to! Here's how it looks:

enter image description here

I've pretty much given up :( Any ideas?

share|improve this question
add comment

1 Answer

up vote 3 down vote accepted

You mean like this?

enter image description here

In Excel, a series usually consists of multiple data points and gets its own entry in the legend. Since you want each data point to get its own entry in the legend, you can simply create multiple series, each with only one data point.

To reproduce the above image, create a scatter plot, as usual. Ensure the chart is selected, then go to Chart Tools -> Design tab -> Select Data. You should see this dialog box:

enter image description here

For each row in your table, add a new series, with the series name, x, and y values like this:

enter image description here

For the chart axis titles, you can add them as usual, select them, then in the formula bar select the cell with the label you want, then press Enter.

share|improve this answer
    
+1! Perfect! Appreciate the effort! –  PhD Mar 2 '12 at 18:01
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.