Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Someone must know
When you make a chart, you use an array of cells. I want to use the sam row to produce values for the y-axis in several charts. I can no specify explicitly in the macro that I want the array to be for exampl c3:c23, because the length of the array changes. If I could define an array which starts at, say c3, and then als specify how many moore elements (from the third row with columns i ascending order) the array should contain (by referring to a cell tha holds this info) that would be fine. help is much appreciated! -- hk -- hk ----------------------------------------------------------------------- hke's Profile: http://www.excelforum.com/member.php...nfo&userid=155 View this thread: http://www.excelforum.com/showthread.php?threadid=26843 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Someone must know
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|