Hello,
I would like to automate the process to click and drag this bar graph to below the pivot table created (so that the graph does not cover the table). May I know how can I do it and which activities to use etc?
Thank you!
Hello,
I would like to automate the process to click and drag this bar graph to below the pivot table created (so that the graph does not cover the table). May I know how can I do it and which activities to use etc?
Thank you!
hi @Steven_Kho,
You can achieve the same using HotKeys
–
Mukesh
Hello @mukeshkala
Thank you for your help!
May I know how do I press the “down” hotkey multiple times, or hold the key for around 2 seconds?
hi @Steven_Kho,
PFB Screenshot for Same - Send Hotkey has property called Delay Before and Delay After - Here in the below screenshot - I have Taken a Delay of 3 sec before and after pressing the down key.
For multiple Down Keys - we can have multiple Send Hot keys.
–
Mukesh
I am not sure why my ‘down’ key doesn’t work. Even if I change it to ‘Left’ key, it won’t work as well.
From, Steven
Can you try the down key - without having selector - I mean - just drag and drop send hotkey and specify only the Key - down and Nothing else … Copy this hotkey multiple time in the workflow.
If it does not work - Try Putting the send Hotkeys outside the excel application scope.
–
Mukesh
Hi @mukeshkala
Both methods mentioned does not work - it did not hold the ‘down’ key for 3 seconds
From, Steven
I have found a solution!
What I did is to “Ctrl + X” to cut the graph,
Ctrl+G to go to the cell I want, and paste it over there
Thank you @mukeshkala for assisting me all this time!
Yes - Nice … We can always Cut and Paste …
–
Mukesh