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
|
|||
|
|||
Dynamic Range Names For a Graph
Hello Everyone. I am having a lot of touble making a graph in excel and was hoping someone could please help me. I have a table of data which is 90 rows long. The data starts on row 8. Each day this table is updated (via a macro) and the new data goes on row 8, and the remaining data is shifted down a row.. ie.. the data on row 8 moves to row 9 etc.. etc.. I am trying to graph the first 15 rows of this table. Lets say j8:J23 and n8:n23 (ie I am graphing the 15 most recent days of data) each time a row is inserted, the row references in the source data for the graph keep changing ie $j$8 would become $j$9.. Could anyone please tell me how to stop the row reference from changing each time a new line is inserted in my table. I have looked at some examples of a Dynamic Range Name but for the life of me I cant get it to work arggg!! Any help would be greatly appreciated. Kind Regards W -- whiZZfiZZ ------------------------------------------------------------------------ whiZZfiZZ's Profile: http://www.excelforum.com/member.php...fo&userid=7394 View this thread: http://www.excelforum.com/showthread...hreadid=513082 |
#2
|
|||
|
|||
Dynamic Range Names For a Graph
Hi,
Stick with the dynamic charting approach. Create two named ranges for the category labels and data ChtLabel: =OFFSET(INDIRECT("Sheet1!$J$8"),0,0,15,1) ChtData: =OFFSET(ChtLabel,0,4) Then the series formula for your chart would be something like, =SERIES(,Book2!ChtLabel,Book2!ChtData,1) Cheers Andy whiZZfiZZ wrote: Hello Everyone. I am having a lot of touble making a graph in excel and was hoping someone could please help me. I have a table of data which is 90 rows long. The data starts on row 8. Each day this table is updated (via a macro) and the new data goes on row 8, and the remaining data is shifted down a row.. ie.. the data on row 8 moves to row 9 etc.. etc.. I am trying to graph the first 15 rows of this table. Lets say j8:J23 and n8:n23 (ie I am graphing the 15 most recent days of data) each time a row is inserted, the row references in the source data for the graph keep changing ie $j$8 would become $j$9.. Could anyone please tell me how to stop the row reference from changing each time a new line is inserted in my table. I have looked at some examples of a Dynamic Range Name but for the life of me I cant get it to work arggg!! Any help would be greatly appreciated. Kind Regards W -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
repost: plz help- dynamic range with gaps? | KR | General Discussion | 2 | August 29th, 2005 08:57 PM |
COUNT /COUNTIF for Multiple Column Defined Dynamic Named Range | Tinä | General Discussion | 1 | October 26th, 2004 01:36 AM |
Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 11:26 PM |
automatic data fill , based on criteria into dynamic range | dave h | General Discussion | 2 | August 25th, 2004 09:47 PM |
Hide data range for a graph | Charts and Charting | 1 | June 17th, 2004 12:20 PM |