ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change graph's source data via macro (https://www.excelbanter.com/excel-programming/318108-change-graphs-source-data-via-macro.html)

flipflop

Change graph's source data via macro
 
I have a graph on an Excel worksheet. Source data is on the same
sheet. If I click the graph I see the blue rectangle drawn around the
source data, and I can move it down one cell by clicking and dragging
the edge of the rectangle.

I'd like to be able to perform this move operation in a macro, and
assign the macro to a keyboard shortcut. This would let me click on
the graph, and then move it along one row at a time with a keypress,
rather than a small click/drag mouse movement.

I can't think of any way to do this -- can anyone help?

Thanks,
flipflop.


All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com