Question

Explain the process of creating a chart using Chart Wizard dialog box.

Answer 1

Answer:

Hello❤

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

Select the cells you want to chart, including the column titles and row labels. These cells will be the source data for the chart. From the Insert tab, click the desired Chartcommand

Answer 2

Answer:

step 1:

go to start and search for microsoft office excel 2007 and open the application.

step 2:

type your input in the cells which should be made into the form of a chart.

step 3:

select the cell range containing the data to be charted.

step 4:

Create the chart by clicking the Chart Wizard button on the standard toolbar.

step 5:

The Chart Wizard starts  by asking what type of chart to make

step 6:

Select a chart type and sub-type that works best for your data and click the Next button.

step 7:

observe if chart is displaying the data correctly. If not use the option buttons and list boxes at this step to adjust the chart data. If the chart appears OK, click the Next button.

step 8:

Click the Legend tab and clear the "Show Legend" checkbox.

step 9:

Click the Data Labels tab and select both Category Name and Value for labels.

step 10:

If using a Pie Chart, clear the Show Leader Lines  option because the pie sections are few and the labels should be clear without leader lines.

step 11:

Click the Next button to continue.

step 12:

click finish