VBA Create a chart from data in an array

Question

I have a sub that that runs a simulation and creates an array with my data. I'd like to make various charts with this data to understand it, but if possible I'd like to avoid pasting the data on worksheet first, is there a way to make a chart directly from the array?

I can paste the data and work around it, but I'm hoping for a more elegant solution

GSerg · Accepted Answer · 2016-01-26 11:58:40Z

1

Documentation gives you the answer.

Charts("Chart1").SeriesCollection(1).Values = Array(1, 3, 5, 7, 11, 13, 17, 19)

answered Jan 26, 2016 at 11:58

GSerg

78.8k18 gold badges173 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA Create a chart from data in an array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related