Select Data For Chart. Selecting Allowed Data from Different Sheets. We can extend this idea to having a formula select the data to be included in the chart.
Add a new data series to the chart by selecting the chart and expanding the data source. Having formulas select the data to be included in the chart In the example above the user selected the data for the chart by entering a Y in Column C for the data points to be charted. You can find the three data series Bears Dolphins and Whales on the left and the horizontal axis labels Jan Feb.
Having formulas select the data to be included in the chart In the example above the user selected the data for the chart by entering a Y in Column C for the data points to be charted.
In the Series value field enter FormulaChartValues note that you need to specify the worksheet name before the named range for this to work. If you are creating a chart and the data is not in rows or columns next to each other you will need to use a different method to select the data. To create a chart the first step is to select the dataacross a set of cells. Select Data Source 1.