Hello!
I have data consisted of 18 columns. From these 18 columns I need to produce 9 graphs. However, i dont need to use entire columns for those,only last non empty cells. For instance, i need to take a value from last nonempty cell from a column A and B and use those two points to construct XY line plot. Then repeat that for C&D,E&F,G&H,I&J,etc. and add those lines to same chart. I dont need to put data in separate columns. Just need to select values from last cells from each two columns and plot them.Could anyone help me creating code like this? Thank you!
I have data consisted of 18 columns. From these 18 columns I need to produce 9 graphs. However, i dont need to use entire columns for those,only last non empty cells. For instance, i need to take a value from last nonempty cell from a column A and B and use those two points to construct XY line plot. Then repeat that for C&D,E&F,G&H,I&J,etc. and add those lines to same chart. I dont need to put data in separate columns. Just need to select values from last cells from each two columns and plot them.Could anyone help me creating code like this? Thank you!
