Question

Long-answer Questions :

1. Write down the steps to create a chart with the help of example.

2.How will you add the following chart elements in a chart?

a. Chart Title:
b. Axis:​

Answer 1

Answer:

1.Create a chart

Select data for the chart.

Select Insert > Recommended Charts.

Select a chart on the Recommended Charts tab, to preview the chart. Note: You can select the data you want in the chart and press ALT + F1 to create a chart immediately, but it might not be the best chart for the data. ...

Select a chart.

Select OK.

2.a)Click the chart, and then click the Chart Design tab. Click Add Chart Element > Chart Title, and then click the title option that you want. Type the title in the Chart Title box. To format the title, select the text in the title box, and then on the Home tab, under Font, select the formatting that you want.

b)Click the chart, and then click the Chart Layout tab. Under Labels, click Axis Titles, point to the axis that you want to add titles to, and then click the option that you want. Select the text in the Axis Title box, and then type an axis title.

Answer 2

Explanation:

The type of chart that you choose depends on the type of data that ... To help simplify things for the users, Excel 2013 and above has an ... Step by step example of creating charts in Excel.