FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -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.

Detailed explanation-2: -In a new worksheet, 2 contextual tabs, design, and format will appear in the main tab. By using the design tab, we can add chart elements, change the chart design, change the colors, change the data range as well, and we can also move chart location as per the requirement.

Detailed explanation-3: -Excel allows us to add or insert desired chart elements, such as chart titles, legends, data labels, etc. Chart elements help make our charts easier to read. To insert a chart element, we need to click on the ‘Add Chart Element’ option under the Design tab, then select the desired element from the drop-down menu.

Detailed explanation-4: -I select the cells that I want to use for the chart, click the Quick Analysis button, and click the CHARTS tab. Excel displays recommended charts based on the data in the cells selected.

Detailed explanation-5: -To create charts that aren’t Quick Analysis options, select the cells you want to chart, click the INSERT tab. In the Charts group, we have a lot of options. Click Recommended Charts to see the charts that will work best with the data you have selected; click All Charts for even more options.