Array of charts.

[Yacwroy]

Hi.

I want to create an array of charts (100s).

Each chart's data range (top, bottom, left, right coordinates) are defined by cells which are physically to the left of the chart. These values of the coordinates are functionally calculated.

Basically I want to be able to cut the block of cells containing the chart and supporting data range, and paste it a few hundred times, and have each graph correspond to the cells beside it.

Currently (after a few issues dealing with how to get 100s of charts on a sheet) I have a 5th cell beside each chart that calculates the "=SERIES()" formula, and then I manually cut this and paste it to each graph's series. However, this is tedious and does not update dynamically.

Is there any way I can:
A: Get the graph to use coordinates defined by function cells?
B: (Not essential but a bonus) Have the position of the above function cells related to the physical coordinates of the graph, (or the graph name, or some other mechanism that will be unique to each graph, and predictable).

I don't want to use VBA, and I would prefer not to use Defined Names.

I'm using Office 2004. I have access to Office 2007 and possibly OpenOffice if they are able to do what 2004 cannot.


Thanks.

[jevni1974]

Hiya,

I think there is not much you can do if you don't want to use VBA or named ranges, but if you can post an example file maybe I can figure out another way for you.