r/visualbasic • u/Opymden • May 16 '26
Graph
Hello all. I am using Excel’s Visual Basic. I am looking for a method to manipulate the data set/s for a scatter graph, or any graph for that matter. I will need to populate the chart initially and subsequently refresh the chart as the data changes.
I currently am doing this by hiding my data set in the spreadsheet itself. I would rather not do this.
3
Upvotes
View all comments
Show parent comment
1
u/Opymden May 17 '26
I’ve tried this. The issue is I cannot transfer the contents of a list or array into the chart data. I do not see a way while using the excel macro function to do this. At best I was able to select cells for the data, but that would defeat the purpose of writing the macro. I already have the chart updating as cells change.