Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Arrays as source data for charts
Is it possible to use arrays (up to 10,000 elements) as source data for charts?
I have been able to get arrays with 28 elements to work with: i = 0 Do Until i = UBound(DataArray, 1) + 1 ReDim Preserve xArray(i) As Double ReDim Preserve yArray(i) As Double xArray(i) = DataArray(i, 0) yArray(i) = DataArray(i, 1) i = i + 1 Loop Charts.Add ActiveChart.ChartType = xlXYScatterLinesNoMarkers ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).XValues = xArray() ActiveChart.SeriesCollection(1).Values = yArray() I am importing data from a text file and i'd rather not put the data in a spreadsheet. Thanks, Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple charts from 1 source data | Charts and Charting in Excel | |||
Editing Source Data in Charts | Charts and Charting in Excel | |||
Updating charts when data source is in a different file | Charts and Charting in Excel | |||
extending source data in several charts | Charts and Charting in Excel | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel |