Series with ea 2 values as single dots

djcampoverde2 · #1 05-02-2005, 11:43 PM

Hi,

I have a series of data, with two values each:

Effort ----- Payback
Process A: 2 ----- 4
Process B: 1 ----- 3
Process C: 2 ----- 4
....

I want to use a x/y diagram in which I represent each process as one dot (or bubble, don't really care), with "effort" and "payback" as the axis.

My problems:
1) It seems I have to enter each line as a series in "data source" for the graph, as otherwise I get two points for each series.
A pain, as I have 60 processes I want to display.

2) whenever two or more points have identical values, Excel puts the labels of the dots on top of each other. That means that
a) it is difficult to see which label goes with which point, as some points are very close to each other
b) I again have to move around up to 60 labels manually.

Any ideas?

Thanks a lot, dJ

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)