| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Chart.SetSourceData method (Excel) |
vbaxl10.chm149162 |
|
|
fc41cc05-087a-f53c-2f54-fd6307de51d6 |
04/16/2019 |
medium |
Sets the source data range for the chart.
expression.SetSourceData (Source, PlotBy)
expression A variable that represents a Chart object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Source | Required | Range | The range that contains the source data. |
| PlotBy | Optional | Variant | Specifies the way the data is to be plotted. Can be either of the following XlRowCol constants: xlColumns or xlRows. |
This example sets the source data range for chart one.
Charts(1).SetSourceData Source:=Sheets(1).Range("a1:a10"), _
PlotBy:=xlColumns[!includeSupport and feedback]