Creating graphs using only last nonempty cells

[rathalex]

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 vertical 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 in same chart . I am new to VBA and not sure how to approach this.

 

[NiMip]

Are you open to having a couple of rows above your dataset for some formulas, or are you keen to use VBA and not disturb the data sheet at all?

 

[rathalex]

I would like to have a vba code for this

 

[rathalex]

Dont wanna disturb data sheet at all