0

Table data

I have the above table, but however I try I cannot get the evidence gap to appear as individual series.

In this example there should be a total of 4 points with the legend of the points being Test, Test 1, Test 2 and Test 3. The plotting should be the Strategic Alignment on the Y axis and Impact on the X axis (although it doesn't matter if this is the reverse)

Every time I try it Impact has the series name or (if I switch row/column), 8 points on the scatter being marked:

Series wrong

Series right, but multiple points

Any help would be great - I thought it would be something simple to plot.

Improve this question

1 Answer 1

Reset to default
0

  1. Only Select the data range (B2:C5) and insert the chart

  2. Select the Data Series in the chart

enter image description here

  1. Right-click on the data series and choose "Add Data Labels" from the dropdown menu

  2. Select the labels, Right-click on them and choose "Format Data Labels" from the dropdown menu

  3. Under "Label Contains", check the "Value From Cells" box and choose the range with the desired labels (in this case A2:A5)

Final result should look like this:

enter image description here

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .