Baz -

Thanks for the feedback. We're just all glad to help.

- Jon

Basil wrote:

Hi Jon,

Perfect - I didn't find the need to have the array formula with {}. It
worked fine without. Very quick and smart! Doesn't even require recipients of
the workbook to have the Bovey add-in to get it to work!
The quadrant was absolutely spot on too - so simple and effective!

John M:
Your solution worked a treat (although with a large range it can take a
while for the VBA to run on every sheet calc and also putting the code on
worksheet_calc can be a bit inconsistent in working - although I found a work
around).
I thought your site was great.

Thanks to all who responded - I now have a variety of techniques that all
work excellently!
I'll get on to the programming or formulas bits to see if I can return the
help to another lost soul!

Many thanks,

Baz

"Jon Peltier" wrote:


Basil -

You need to have a worksheet range that holds the values of the defined
range of labels. If the size of the dynamic range is unbounded, this
will be an issue, but if you know it will always be less than, say, 50
items, select an unobtrusive range, F1:F50 for example, and enter this
array formula

=MyDynamicLabels

and hole CTRL+SHIFT while pressing Enter. If you do this right, Excle
puts the formula within curly braces:

{=MyDynamicLabels}

Then fill the data range with dummy values (zeros), make a series in the
chart with 50 points, and use Rob's Labeler to use the worksheet range
F1:F50 for its labels. Clear out all the dummy values from the data
range, and proceed. Each point in the series will remember which cell
contains its label, even if the dynamic range causes fewer points to
appear. When it reappears, it will remember the link.

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


Basil wrote:

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