If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Indirect Range Referencing
Hello, I work in a paper mill. I am building a spreadsheet with several charts. I have a wide sheet of paper coming off of a paper machine of varying widths. This paper is wound up on a "reel".I have a scanner that measures the weight of the paper on the reel, and each scan gives me a 600 point array. I can calculate where the edges of the paper lie within the array, no problem, and plot the whole thing very nicely. The problem is that the paper then goes into a re-winder, where the wide sheet is cut into smaller sheets, that make up "rolls". I can calculate the start and stop cell address of each roll within the array and deliver it to a cell which, if I could use as an indirect address in a chart range, I could plot each roll's weight on a different chart. Like if D:21 contained the Roll 1 starting cell of AH:591 and D:22 contained the Roll 1 stopping cell of AH:415. I want to define the charts series as indirect D:21 to indirect d:22. Can anyone help with this? Thanks Jeff -- jeaton ------------------------------------------------------------------------ jeaton's Profile: http://www.excelforum.com/member.php...o&userid=31409 View this thread: http://www.excelforum.com/showthread...hreadid=511040 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dynamic Range with unused formula messing up x axis on dynamic graph | [email protected] | Charts and Charting | 2 | February 2nd, 2006 08:02 PM |
Using a worksheet name from a range | RPH | Worksheet Functions | 3 | January 27th, 2006 08:40 PM |
VBA: For Each Cell in Range jumps out of range? | Ed | Tables | 2 | January 26th, 2006 05:51 PM |
referencing named formula using INDIRECT function | [email protected] | Worksheet Functions | 19 | May 11th, 2005 09:48 AM |
indirect referencing | stephen.reading100 | General Discussion | 1 | November 18th, 2004 12:49 AM |