XY chart labeller Issue: (Magic quadrant) But with a twist.
 

Hiya Folks

I have the same problem as has already been discussed on the forum (see
below@ end of my email), but in my case there is an additional twist.

The orginal issue was solved by using Rob Bovey's XY Chart Labeler to add
labels. The free download is at his web site:

http://www.appspro.com/Utilities/ChartLabeler.htm


But in my case I have lots of XY points (155 to be precise). The problem is
that 155 visible labels make the chart look very messy. Is there anyway to
make the XY labels invisible until you hover over them with a mouse/pointer?

Any help would be greatly appreciated

Steve

Orginal Problem.

I need to create a chart which is a matrix of four 'boxes' (a bit like the
BCG 'Cash cow, star, etc matrix if you know it). But am having real trouble.

What I need is this (and I'm going for the simplest method here - I ignored
the four 'boxes' and just tried to get the data as I want on the chart):

Data source:

Project Name Value(1-10) Difficulty(1-10)
Proj1 5 8
Proj2 8 10
Proj3 1 8
Proj4 3 2
Proj5 6 4

Chart:

Y-Axis: Value
X-Axis: Difficulty
Label next to each point: Project Name

So, with this graph there would only actually be 5 points - 1 for each
project. And each point would have the project name next to it.

I'll make a crude effort at drawing it:

val)
10 |
| X proj2
| X proj5
| X proj1
| X proj4
|
1 |_____________________X proj3__
1 10 (diff)

I had very moderate success with 'bubbles' - but hit a dead end.
Anyone know how I can achieve this??

XY chart labeller Issue: (Magic quadrant) But with a twist.
 

Try Tushar's Hover Chart Label utility:

http://tushar-mehta.com/excel/softwa...bel/index.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Steve" wrote in message
...
Hiya Folks

I have the same problem as has already been discussed on the forum (see
below@ end of my email), but in my case there is an additional twist.

The orginal issue was solved by using Rob Bovey's XY Chart Labeler to add
labels. The free download is at his web site:

http://www.appspro.com/Utilities/ChartLabeler.htm


But in my case I have lots of XY points (155 to be precise). The problem
is
that 155 visible labels make the chart look very messy. Is there anyway to
make the XY labels invisible until you hover over them with a
mouse/pointer?

Any help would be greatly appreciated

Steve

Orginal Problem.

I need to create a chart which is a matrix of four 'boxes' (a bit like the
BCG 'Cash cow, star, etc matrix if you know it). But am having real
trouble.

What I need is this (and I'm going for the simplest method here - I
ignored
the four 'boxes' and just tried to get the data as I want on the chart):

Data source:

Project Name Value(1-10) Difficulty(1-10)
Proj1 5 8
Proj2 8 10
Proj3 1 8
Proj4 3 2
Proj5 6 4

Chart:

Y-Axis: Value
X-Axis: Difficulty
Label next to each point: Project Name

So, with this graph there would only actually be 5 points - 1 for each
project. And each point would have the project name next to it.

I'll make a crude effort at drawing it:

val)
10 |
| X proj2
| X proj5
| X proj1
| X proj4
|
1 |_____________________X proj3__
1 10 (diff)

I had very moderate success with 'bubbles' - but hit a dead end.
Anyone know how I can achieve this??