| {\rtf1\ansi\ansicpg1252\deff0\deflang1044{\fonttbl{\f0\fnil\fcharset0 MS Sans Serif;}} \viewkind4\uc1\pard\f0\fs17 As you know, the MSChart will accept data from an array. However, when you provide data in a single-dimensioned array, you may have wondered how to supply labels for the data series. Fortunately, you can supply this information in the array as well. When building a chart from an array, MSChart will accept the first series of a multi-dimensional array as strings. It will then use these values as series labels. The following code shows how we might accommodate this behavior to display the labels \par \par Dim ary(1 To 10, 1 To 2) As Variant \par With MSChart1 \par \tab For X = 1 To 10 \par \tab\tab ary(X, 1) = "Label" & X \par \tab\tab ary(X, 2) = X * 2 \par \tab Next X \par \tab .ChartData = ary \par End With \par \par Also notice that because the array must contain both string and integer data, we had to declare it as a Variant data type. \par } |
Assign labels when using an array with MSChart |
India web developer web development India | India web development company India ecommerce web developer