Question

how do you add the chart in excel?

Answer 1

Select the cells you want to chart, including the column titles and row labels. These cells will be the source datafor the chart.

From the Insert tab, click the desired Chart command

Choose the desired charttype from the drop-down menu.

The selected chart will be inserted in the worksheet

After inserting a chart, there are several things you may want to change about the way your data is displayed. It's easy to edit a chart's layout and style from the Design tab.

• Excel allows you to add chart elements—such as charttitles, legends, and datalabels—to make your chart easier to read. To add a chart element, click the Add Chart Element command on the Design tab, then choose the desired element from the drop-down menu.
• To edit a chart element, like a chart title, simply double-click the placeholder and begin typing.
• If you don't want to add chart elements individually, you can use one of Excel's predefined layouts. Simply click the Quick Layoutcommand, then choose the desired layout from the drop-down menu.
• Excel also includes several different chart styles, which allow you to quickly modify the look and feel of your chart. To change the chart style, select the desired style from the Chart styles group