I wish to plot a simple line chart with only last 20 values in column C and G but do not know how to define the range "last 20 rows" because total number of rows differ from 450 to 500 from file to file. Could someone tell me how to define this dynamic range of values, so that I can use the same in a macro to plot charts in 100s of files in different folders.
Bookmarks