Option 1 Name Manager Dialog window If you select a welldefined worksheet range and insert a chart, Excel parses the range and assigns values (Y values), categories (X values), and series names based on its analysis of the range For example, if you select the range C2F8 shown below, Excel notices that the top left cell C2 is blank, so Row 2 and Column C will be treated differentlyWhen you create a chart in Excel and the source data changes, you need to update the chart's data source to make sure it reflects the new dataIn case you wo
Excel Tutorial How To Create A Dynamic Named Range With A Table
