In the Names in workbook box, type Date.
In the Refers to lokale myndigheter søker west sussex box, type the following text: Click Add, and then click.
In the Name box, type Sales.
Note If you are creating a series chart that plots every value in an adjacent block of lokale nyheter lewes east sussex cells in single column, and the block of cells starts with the first row, you can use either of the following formulas in the Refers to box for.
Click the titles that you want to display and click Finish.For example, the formula might be similar to the following: Sheet1!Date Click the Name And Values tab.For example, the formula might be similar to the following: Sheet1!Date In the Values box, replace the cell reference with the defined name Sales.Click the X Values tab.Microsoft Excel.0 or Microsoft Excel.0 On the Insert menu, point to Chart, and click As New Sheet to start the Chart Wizard.To do this, follow these steps, as appropriate for the version of Excel that you are running.To plot adjacent nonnumeric entries (for example, labels use counta instead of count).
For more information, please visit our privacy page.
In the X Values box, replace the cell reference with the defined name Date.
In the Y Values box, replace the cell reference with the defined name Sales.
Make any changes you want in step 3 of the Chart Wizard and click Next.
The chart appears on a new chart.Method 1: Use offset with a defined name.The formula automatically updates the offset formula that is used in the defined name "Sales" when you enter new data into column.Name box, type Date.Select the data series.Click the Series tab.This section includes two methods for using defined names to automatically update the chart range.On the, insert tab, click a chart, and then click a chart type.
In the Series values box, type Sheet1!Sales, and then click.