DATABASE FUNDAMENTALS
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: -You can use the Select Data Source dialog box to add, edit, remove and move data series, but there’s a quicker way. 1. Select 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.