How to plot dataset depending on two variables in schattered table

[teilnemer]

Hello,

I need to relate how the profitability of a number of projects is relate. I provide below a table with a sample of data.

I use a schatted table (single points). I want each point in the table to have the name, performance and GM associated.
I have tried two things:

1:

Select name´: first name
select Y data: first value of Performance column
select X data: firts value of GM column

In this case I have the point plotted how I want and with the name, performance and GM individually associated. But here each point is represented by a different symbol, and I want all the symbols to be the same.

So I tried the following:

2:
Select Y data: entire "performance" column
Select X data: entire "GM" column

Here all the points all plotted rightly and with the same symbol, but I can not associate the individual projects names to each point.


Can someboday help? I am getting a bit frustrated. i am sure the solution is quite simple but I can not find it.

Thanks in advance

Project Performance Gross margin
project 1 4.697 23,35%
project 2 3.580 24,20%
project 3 2.641 17,33%
project 4 2.453 17,03%
project 5 2.337 14,58%
project 6 2.307 5,20%
project 7 2.100 8,19%
project 8 1.999 14,57%

[Steve=True]

Unfortunately there is no easy way.

Instead of one big data series, for a small data set the easiest way is to make a chart with one data point.

Then copy and paste special each data point as a new series one at a time.

Steve=True