How do i display a graph that will only display when a cell is clicked or cursor touches?

[trippyninjas]

I need to display a line graph from 2 cell values (Vertical & Horizontal) but i am having some trouble with it.

Is there any way to display the graph only when my cursor touches or clicks onto the cell?
The cell values are required to have "V/m Vertical/Horizontal" included so the code will need to skip the String and extract the numbers.

I have uploaded my vba file & code below. Any suggestions will be helpful. Thanks

Please Login or Register  to view this content.

[Kaper]

Let me start from a comment: I don't understand why you thrown away a nice piece of work done by mehmetcik in previous thread https://www.excelforum.com/excel-pro...isplay-it.html
He has shown you, that there can be single procedure to do all major work (it was called MinMax there) and the code for each button can be just a call to this procedure with an argument (like worksheet row).
Now you went back to your code with all the work being done in each of the buttons code :-(

To the merit:
The simple solution, based on a registered macro consists of the procedure deleting a graph (if already exists) and re-creating it. The data to be displayed is passed in a named range.

As there were no sample graphs to be obtained, I assumed that this: "I need to display a line graph from 2 cell values" means you need only graph from the last range clicked. (see the code below)
If you need to have all ranges displayed the code shall be changed to only add a new series (and if only if needed - create a graph) - this approach is used in a workbook attached.

So in a standard module a code:

Please Login or Register  to view this content.

And the procedures in the "Program sheet code with added calls to this procedure, like:

Please Login or Register  to view this content.

[trippyninjas]

Greetings Kaper,

The MiniMax function is not wasted. I just had a little issue with the way the properties are being layed out (different from the previous program) in my actual application. Do allow me to explain myself.

Based on my understanding of mehmetcik's MiniMax function, it can only be used if the properties are layed out in a well arranged order (Just like my previous program) and thus reads the properties row by row.

OGproperties.PNG

Unfortunately, i realised that the properties given to me (company confidential) is layed out in a way like this instead:

new properties.PNG

Due to my limited understanding of the MiniMax's function i faced some trouble this scenario and therefore, i had to individually assign each cell in my program to each cell in the properties sheet. I may have underestimated the capabilities of MiniMax so do let me know if i can still use it in this application with the new property layout. Thank you.

Best regards,
Christian

[trippyninjas]

Hi Kaper,

The program works well but i'm having some trouble understanding it. Is there a method to produce individual graphs for every set of horizontal & vertical values? Also, how do i manually set the x & y-axis range values of the generated graph?

Best regards,
Christian