USING MICROSOFT EXCEL
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Select an entirely new range of data or Exclude some data from the chart
|
|
|
Delete data from a selection
|
|
|
Select what color is used for each data series on the chart
|
|
|
Change to a new type of chart
|
|
|
None
|
Detailed explanation-1: -Right-click the chart, and then choose Select Data. The Select Data Source dialog box appears on the worksheet that contains the source data for the chart. Leaving the dialog box open, click in the worksheet, and then click and drag to select all the data you want to use for the chart, including the new data series.
Detailed explanation-2: -To remove a chart’s data series, click “Chart Filters” and then click “Select Data.” Select the series in the Legend Entries (Series) box, and then select “Remove.” Click “OK” to update the chart.
Detailed explanation-3: -What is a Dynamic Chart Range? A dynamic chart range is a data range that updates automatically when you change the data source. This dynamic range is then used as the source data in a chart. As the data changes, the dynamic range updates instantly which leads to an update in the chart.