Go to Jon Peltier's site:

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

go to dynamic and interactive charts to see how to set up a dynmamic range.

--
Regards,
Tom Ogilvy

"hke" wrote in message
...

When you make a chart, you use an array of cells. I want to use the same
row to produce values for the y-axis in several charts. I can not
specify explicitly in the macro that I want the array to be for example
c3:c23, because the length of the array changes.

If I could define an array which starts at, say c3, and then also
specify how many moore elements (from the third row with columns in
ascending order) the array should contain (by referring to a cell that
holds this info) that would be fine.

help is much appreciated!

--
hke


--
hke
------------------------------------------------------------------------
hke's Profile:
http://www.excelforum.com/member.php...fo&userid=1550
View this thread: http://www.excelforum.com/showthread...hreadid=268434