Create Chart from Array data and not range

by

Yes. You can assign arrays to the XValues and Values properties of a Series object on a chart. Example:

Dim c As Chart
Dim s As Series
Dim myData As Variant

Set c = ActiveChart ' Assumes a chart is currently active in Excel...
Set s = c.SeriesCollection(1)

myData = Array(9, 6, 7, 1) ' or whatever
s.Values = myData

More Related Contents:

  1. Creating an Array from a Range in VBA
  2. Excel VBA: Range to String Array in 1 step
  3. Excel-VBA – Insert new first column in datafield array without loops or API calls
  4. Expanding column cells for each column cell
  5. How do I slice an array in Excel VBA?
  6. Check if a value is in an array or not with Excel VBA
  7. Matching values in string array
  8. Deleting Elements in an Array if Element is a Certain value VBA
  9. Is it possible to fill an array with row numbers which match a certain criteria without looping?
  10. How to automatically input an array formula as string with more than 255 characters in length into an excel cell using VBA?
  11. Return Index of an Element in an Array Excel VBA
  12. Writing an array to a range. Only getting first value of array
  13. Faster way of using Sumifs()
  14. How to initialize a multidimensional array variable in vba for excel
  15. VBA using ubound on a multidimensional array
  16. Turn Excel range into VBA string
  17. Get values from union of non-contiguous ranges into array with VBA with a simple command (no loops)
  18. Why am I having issues assigning a Range to an Array of Variants
  19. Subscript out of range error with an array – no idea why?
  20. VBA Excel large data manipulation taking forever
  21. Performance difference between looping range vs looping array
  22. Excel VBA Quickest way to sort an array of numbers in descending order?
  23. Simple VBA array join not working
  24. Excel VBA – How to Redim a 2D array?
  25. VBA: Modify chart data range
  26. ReDim Preserve “Subscript Out of Range”
  27. VBA array sort function?
  28. How to find if an array contains a string [duplicate]
  29. VBA Dialog box to select range in different workbook
  30. Change the Point Color in chart excel VBA

Leave a Comment