I have been trying to make an excel chart that automatically updates with the information coming in the form of a new column input . I am struggling to get the offset and count functions to do this.
By following "http://support.microsoft.com/kb/183446" i can get a chart automatically updating down a column but i need it to update as the relevent information jumps across 3 columns along a given row.
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
Doing this will ensure you get the result you need!
Alright, attached is the dummy form displaying the structure and the relevent information. Graph 1 needs to display the most recent information (ie the thickness at the most resent available date) and the second graph needs to add another value each time more information is added to the form. All the multicoloured lines are there to show constant thicknesses
The dynamic range definition for this would be
=OFFSET(Dummy!$A$7:$A$15,0,MATCH(99^99,Dummy!2:2,1)-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks