I am glad that you like it! But I am no Excel Genius. Go check out some of the Aladin and Houdini's of the Mr Excel Message Board! Those Excelers know 1000 times more than I do!
Great to see dynamic chart work with INDEX(), kind of easier than with OFFSET() function, nevertheless both functions are quite useful .Trick getting last three values is also amazing. =INDEX($B$61:$B$76,COUNT($B$61:$B$76)-$M$60+1):INDEX($B$61:$B$76,COUNT($B$61:$B$76)). Thanks.
there seems to be a problem using the INDEX-COUNT combination for Dynamic charts as if I use the tip on selecting that Last number of cells, it does not go to the very last cell, I do not know why it always goes to the 2nd to the last cell. Is this a glitch?? I am using Excel 2007
I am glad that you liked it! Yes, an 'n' dynamic chart is quite nice!
@ExcelIsFun
Excellent tip! Thank you.
More interesting is to make a graph of the top n -dynamic.
Thanks for the 5 stars!
Thank u for this video was so easy and useful for me
I am glad that you like it!
But I am no Excel Genius. Go check out some of the Aladin and Houdini's of the Mr Excel Message Board! Those Excelers know 1000 times more than I do!
Great to see dynamic chart work with INDEX(), kind of easier than with OFFSET() function, nevertheless both functions are quite useful .Trick getting last three values is also amazing. =INDEX($B$61:$B$76,COUNT($B$61:$B$76)-$M$60+1):INDEX($B$61:$B$76,COUNT($B$61:$B$76)). Thanks.
Awesome video as always. What about Dueling Excel?I have seen any dueling clips for quite a while
Mr Excel took a leave for a while. But funny you should ask, tomorrow he is starting it up again!
Very Cool.
I could not find the excel spreadsheet on your web site. Would you mind sending me the link to that workbook.
there seems to be a problem using the INDEX-COUNT combination for Dynamic charts as if I use the tip on selecting that Last number of cells, it does not go to the very last cell, I do not know why it always goes to the 2nd to the last cell. Is this a glitch?? I am using Excel 2007