DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Change Chart Type
|
|
|
Add Chart Element
|
|
|
Quick Layout
|
|
|
Move Chart
|
Detailed explanation-1: -On the Design tab, in the Type group, click Change Chart Type. In the Change Chart Type dialog box, click a chart type that you want to use.
Detailed explanation-2: -You can use Quick Layout to change the overall layout of the chart quickly by choosing one of the predefined layout options. Step 1 − On the Ribbon, click Quick Layout. Different predefined layout options will be displayed.
Detailed explanation-3: -Right-click your chart, and then choose Select Data. In the Legend Entries (Series) box, click the series you want to change. Click Edit, make your changes, and click OK.
Detailed explanation-4: -Once you have a chart in Excel, you can easily change from one chart type to another. Just select the chart and click “change chart type” on the Design tab of the ribbon. Excel will open the change chart type window, where you can browse and select other chart types.
Detailed explanation-5: -On the Insert tab, in the Illustrations group, click Chart. In the Insert Chart dialog box, click the arrows to scroll through the chart types. Select the type of chart that you want and then click OK.