Per Jon Peltier:
.Rows.Count and .Columns.Count only look at the first area of a
discontiguous range. You can do a loop:

I think I'm trying to fool Mother Nature on this one.... with the discontinuous
range.

Seems like a more direct approach would be for me to just pick apart the larger
range cell-by-cell and grab what I need.

But that means that I'd need to store that range address somewhere in the chart
object. The series behind the chart won't do because it's just a subset of the
larger range. But when I create the chart, I know what the larger range is.

Tried .Chart.Name (after massaging the range, replacing ":" with "-") but it
didn't take.

Looked for something like .Tag, but didn't find it.

Can you think of some chart or shape property that I could use to squirrel away
a range address like "R3C02:R25C17"?

Even if I could make .Name stick, it would seem a dicey in that two charts with
the same macro data range would break my little scheme.
--
PeteCresswell

In line -

"(PeteCresswell)" wrote in message
...
Per Jon Peltier:
.Rows.Count and .Columns.Count only look at the first area of a
discontiguous range. You can do a loop:

I think I'm trying to fool Mother Nature on this one.... with the
discontinuous
range.

Seems like a more direct approach would be for me to just pick apart the
larger
range cell-by-cell and grab what I need.

Why doesn't Jon's advice work for you.

But that means that I'd need to store that range address somewhere in the
chart object.

Isn't the range defined and hence stored in the series formula(s)

The series behind the chart won't do because it's just a subset of the
larger range. But when I create the chart, I know what the larger range
is.

Tried .Chart.Name (after massaging the range, replacing ":" with "-") but
it
didn't take.

Chart names are more restricted than shape names in terms of allowable
punctuation characters. Replace ":" in the formula with something,
underscore is good.

Looked for something like .Tag, but didn't find it.

There's no tag or Alternative text property. Some text box perhaps, made not
visible.

Can you think of some chart or shape property that I could use to squirrel
away
a range address like "R3C02:R25C17"?

Why R1C1 and not A1, look at app.ConvertFormula. What happens if the
harcoded range is moved !


Even if I could make .Name stick, it would seem a dicey in that two charts
with
the same macro data range would break my little scheme.
--
PeteCresswell

Regards,
Peter T

Looked for something like .Tag, but didn't find it.

There's no tag or Alternative text property. Some text box perhaps, made
not
visible.

I suggested this (and provided a code sample) in Pete's more recent thread
which asked about .Tag.

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

Per Peter T:
Seems like a more direct approach would be for me to just pick apart the
larger
range cell-by-cell and grab what I need.

Why doesn't Jon's advice work for you.

Dunno - but the first thing that comes to mind is RCI on my part...


But that means that I'd need to store that range address somewhere in the
chart object.

Isn't the range defined and hence stored in the series formula(s)

Yes. But the range I need is different from the chart's. It's a superset
of the chart range from which I'd extract some rows/columns to place
below the chart.


Chart names are more restricted than shape names in terms of allowable
punctuation characters. Replace ":" in the formula with something,
underscore is good.

I tried a dash... but no go. I'll give the underscore a shot...

But now I'm re-thinking my whole strategy. This started because I'm creating
many chart objects in one process and arranging them in another process.

I think I need to combine the two processes so that I position/size each chart
when I create it. At that time I have access to the data I need so I should be
able to also place the supplemental data beneath the chart at that time.
--
PeteCresswell