I have a problem creating a graph and integrating it with a macro.
I hope somebody can show me how to do it.
I attached two xlsm files to illustrate my problem. Both Excel files contain an identical macro. The macro creates a new workbook and generates a table of random data.
The file WithGraph.xlsm has a graph. This is the positive control. The graph does what it is supposed to do. That is allowing the user to scroll up and down through the data. In the NoGraph.xlsm file I deleted the graph. I tried to recreate it but I failed.
First question:
How do I recreate this graph?
Second question:
Is there a way to use a macro to create this graph?
Bookmarks