beginner charting question

[yoshe]

Hello,
Is it necessary to first write data to a worksheet in order to create a chart for it? I have a model that reads data from a text file and would like to create the chart in vba without first outputting the data to a worksheet. Is this possible? Thanks for any help.

 

[SkipVought]

Hi,

yes, it is possible, but it would be a WHOLE lot more difficult than IMPORTING the data and then plotting the data, especially if the data need to be further summarized for the chart.

The plot data can be assigned as an array.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]