Thank you so much both of you, these are both absolutely fabulous and combine
perfectly for exactly what I was after!

There is just the 1 more thing I am struggling with:
I want to make the chart look at (and adjust to) a dynamic range.
Since it is not a simple case of a chart looking at a rectangular
datasource, I am struggling.

With Rob Bovey's XY Chart labeler, I also have the problem that although it
does accept a named range, if (as in my instance) the named range is a
varying off-set formula - when I add to the range having already added the
labels, it will not re-asses the named range to add the additional row.

Does that make sense?

Any ideas?

Thanks again, your tips have been magic.

Basil

"Jon Peltier" wrote:

Basil -

You can build a quad chart using this technique:

http://peltiertech.com/Excel/Charts/...ackground.html

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

Basil wrote:

Hiya,

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??

Many thanks,

Basil