Usually when we plot graph in MS Excel we start with numbers inside a spreadsheet. We then select these numbers and then select a graph type to plot the data. This means that ever single value being plotted must be present inside cells in a spreadsheet.
VBA can have values stored inside variables. This is akin to how it works with Python or MATLAB. In the Python and MATLAB we can provide the data be plotted as parameter into a function and the graph will be created. Is the same possible with Excel VBA as well? In other words, can I have data inside Excel VBA variables and plot graph directly from them without having the values inside a spreadsheet? Or must I first write the values from VBA into a spreadsheet and then invoke the command which shall plot the data?
Bookmarks