Charting question

[mortgageman]

In the following type of line, can the "source" be a VBA variable? In other words, if I calculate in VBA, can I go directly to the chart, or do I have to write to a range and then chart?


ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("B1:C2"), PlotBy:= _
xlRows

Gene, "The Mortgage Man", Klein

 

[Jon Peltier]

In Windows Explorer:
Right click > Send To > Compressed (Zipped) Folder

 

[mortgageman]

Okay I sent the zipped file but I have not received the automated reply that the instructions say I would. It has been about 3 hours since I sent it.

Gene, "The Mortgage Man", Klein