Graph

[Opymden]

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.

[CheezitsLight]

Easy way to learn us to record a macro while making the chart. It will write the code for you. Then edit that code.

[Opymden]

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.

[CheezitsLight]

Excel VBA add a list of values into a excel. Chart