Creating scatter chart with data point labels

[Terry]

I have categorized jobs on a scale of 1-10 for Ease of
Implementation (1=hard, 10=easy) and 1-10 for Value
Returned. I want to plot these so the easy, high value
jobs appear in the upper-right quadrant, hard, low-value
jobs in the lower left, etc. Data might look like:

Task Ease Value
Job1 10 10
Job2 1 1
Job3 3 9
Job4 6 2

The result would have job1 in the upper right corner (very
easy, very high value), job2 in the lower left corner (not
at all easy, very little value), job 3 middle of upper-
left quadrant (not very easy but high value), etc.

I can create a scatter chart just using the numbers but
there is no connection from the plotted point to the Task
name, so hovering the cursor over where Job1 is plotted
tells me the point is (10,10). If I create a scatter chart
using all 3 columns (Task, Ease, Value) it creates 2 data
series with the X value being the ordinal position of the
data item (Job1 has X value 1 because it is the first data
item, etc).

Ideally I would like the name of the task to appear where
the point is plotted but seeing the name when hovering the
cursor over the point would be fine. The purpose is to
graphically represent how much "bang for the buck" we
expect to get from completing each job.

This doesn't seem like it would be hard but I'm stuck.

Thanks for the help,

Terry

 

[dvt]

I have categorized jobs on a scale of 1-10 for Ease of
Implementation (1=hard, 10=easy) and 1-10 for Value
Returned. I want to plot these so the easy, high value
jobs appear in the upper-right quadrant, hard, low-value
jobs in the lower left, etc. Data might look like:

Task Ease Value
Job1 10 10
Job2 1 1
Job3 3 9
Job4 6 2

The result would have job1 in the upper right corner (very
easy, very high value), job2 in the lower left corner (not
at all easy, very little value), job 3 middle of upper-
left quadrant (not very easy but high value), etc.

I can create a scatter chart just using the numbers...

That's a great first step.

Ideally I would like the name of the task to appear where
the point is...

Now use Rob Bobey's XY Chart Labeler (www.appspro.com) to apply data labels
to your series. Using his utility, it took me about 30 seconds to create a
rough draft of the chart you want.

Dave
dvt at psu dot edu

 

[Jon Peltier]

That's okay, Dave. With practice you'll get faster.

- Jon

 

[Terry]

Dave,

Awesome tool, does just what I need. Thanks for the
pointer.

Terry