I have to create 2 Scatter graph every week from 3 sheets in a work book that contains reading1 and reading 2 at different times. Can any one please help me how to write this code.
I even tried replying the recorded macro the caused excel file to stop responding and had to kill the application.
I am a java programmer but new to excel macros.
Thank you in advance
unable to upload excel file.
Vikram
Sample data
Day Start Time Reading1 Reading2 Sun 3:00 0 0 Sun 3:58 0 0 Sun 4:27 0.02 0.03 Sun 4:58 0 0 Sun 5:27 0 0 Sun 5:57 0.08 0.01 Sun 6:28 0.02 0 Sun 6:58 0.12 0.27 Sun 7:57 0.22 0.63 Sun 8:02 0.16 0.23 Sun 8:29 0.26 1.07 Sun 8:59 0.11 0.32 Sun 9:28 0.06 0 Sun 9:58 0.09 0 Sun 10:27 0.04 0 Sun 10:56 0.02 0.02 Sun 12:01 0.06 0.13 Sun 12:40 0.03 0.09 Sun 12:43 0.04 0.04 Sun 12:58 0.03 0.01 Sun 13:29 0.05 0.02 Sun 13:57 0.1 0.11 Sun 14:37 0.44 0.12 Sun 14:48 0.06 0.14 Sun 14:59 0.08 0.05 Sun 15:29 0.01 0 Sun 15:56 0.03 0 Sun 16:22 0.05 0 Sun 16:27 0 0 Sun 16:58 0.05 0.03 Sun 17:33 0.11 0.19 Sun 17:59 0.06 0.07 Sun 18:30 0.1 0.04 Sun 18:58 0.11 0.1 Sun 19:27 0.21 0.18 Sun 20:00 0.26 0.82 Sun 20:28 0.23 0.16 Sun 22:01 0.08 0.01 Sun 22:30 0.18 0.59 Sun 22:56 0.09 0.17 Sun 23:28 0.06 0.3 Sun 23:57 0 0
I even tried replying the recorded macro the caused excel file to stop responding and had to kill the application.
I am a java programmer but new to excel macros.
Thank you in advance
unable to upload excel file.
Vikram
Sample data
Day Start Time Reading1 Reading2 Sun 3:00 0 0 Sun 3:58 0 0 Sun 4:27 0.02 0.03 Sun 4:58 0 0 Sun 5:27 0 0 Sun 5:57 0.08 0.01 Sun 6:28 0.02 0 Sun 6:58 0.12 0.27 Sun 7:57 0.22 0.63 Sun 8:02 0.16 0.23 Sun 8:29 0.26 1.07 Sun 8:59 0.11 0.32 Sun 9:28 0.06 0 Sun 9:58 0.09 0 Sun 10:27 0.04 0 Sun 10:56 0.02 0.02 Sun 12:01 0.06 0.13 Sun 12:40 0.03 0.09 Sun 12:43 0.04 0.04 Sun 12:58 0.03 0.01 Sun 13:29 0.05 0.02 Sun 13:57 0.1 0.11 Sun 14:37 0.44 0.12 Sun 14:48 0.06 0.14 Sun 14:59 0.08 0.05 Sun 15:29 0.01 0 Sun 15:56 0.03 0 Sun 16:22 0.05 0 Sun 16:27 0 0 Sun 16:58 0.05 0.03 Sun 17:33 0.11 0.19 Sun 17:59 0.06 0.07 Sun 18:30 0.1 0.04 Sun 18:58 0.11 0.1 Sun 19:27 0.21 0.18 Sun 20:00 0.26 0.82 Sun 20:28 0.23 0.16 Sun 22:01 0.08 0.01 Sun 22:30 0.18 0.59 Sun 22:56 0.09 0.17 Sun 23:28 0.06 0.3 Sun 23:57 0 0
Last edited: