(i) Select the data range to be used in creating a chart. It is recommended that row or column headings are included in range selection.
(ii) Click on the Chart Wizard tool to start the Chart Wizard.
This displays the Chart Wizard dialog box, where you are asked to select a chart type.
(iii) Select Bar Graph from the all types of charts shown in the Chart Type list. ( You can always make changes later). When you select a type, the information in the Chart Sub-type area of the dialog box is changed.
(iv) Click the right Chart Sub-types shown at the right side of the dialog box.
(v) Click on Next. Excel proceeds to the second step of the ChartWizard, where your information is first presented as a chart.
(vi) Make any necessary changes to the data range depicted in the dialog box, then click on Next. Excel displays the third step of the Chart Wizard.
(vii) Using the controls in the dialog box, indicate the title, labels, and other formatting you want used for your chart. As you make changes, notice that the sample chart is updated to reflect your changes.
(viii) When you are satisfied with your formatting settings, click on the Next button. Excel displays the final step of the ChartWizard. Here, you select whether you want your chart embedded in your worksheet or to appear on its own new chart sheet.
(ix) Click on Finish. Your chart is created as you directed.
maurice.mutuku answered the question on April 10, 2018 at 12:05
- It is often desirable and necessary to produce a chart to graphically present the data that you have created in your spreadsheet. What precaution would...(Solved)
It is often desirable and necessary to produce a chart to graphically present the data that you have created in your spreadsheet.
Highlight the precautions you would take before you produce a chart.
Date posted: April 10, 2018. Answers (1)
- How would you place a chart on your worksheet?(Solved)
List ways of placing a chart on your worksheet.
Date posted: April 10, 2018. Answers (1)
- Define the term DSS(Solved)
Define the term DSS.
Date posted: April 10, 2018. Answers (1)
- What are the types of charts in a spreadsheet?(Solved)
Discuss the types of charts in a spreadsheet.
Date posted: April 10, 2018. Answers (1)
- Mr Michael Mwamburi realized that after sorting the names of Form III class list based on the First Name column in ascending order, there were...(Solved)
Mr Michael Mwamburi realized that after sorting the names of Form III class list based on the First Name column in ascending order, there were some ties on similar names that appeared in a disorganized manner.
Advise him on how to break the tie.
Date posted: April 10, 2018. Answers (1)
- Why would you prefer to use forms for data entry in a worksheet than entering data directly onto the cells?(Solved)
Give the reason why you would prefer to use forms for data entry in a worksheet than entering data directly onto the cells.
Date posted: April 10, 2018. Answers (1)
- What is the difference between "Autofilter" and "Advanced Filter?"(Solved)
Differentiate between "Autofilter" and "Advanced Filter"
Date posted: April 10, 2018. Answers (1)
- What is the difference between Sorting and filtering?(Solved)
Differentiate between Sorting and filtering.
Date posted: April 10, 2018. Answers (1)
- What types of format are you likely to carry out on data in a worksheet?(Solved)
Give the types of format you are likely to carry out on data in a worksheet.
Date posted: April 10, 2018. Answers (1)
- What is the difference between "justify" with "Center across selection?"(Solved)
Distinguish between "justify" with "Center across selection"
Date posted: April 10, 2018. Answers (1)
- How would you adjust the column width entries to best fit in your spreadsheet?(Solved)
Explain how you would adjust the column width entries to best fit in your spreadsheet.
Date posted: April 10, 2018. Answers (1)
- What are the golden rules of formatting?(Solved)
List the golden rules of formatting.
Date posted: April 10, 2018. Answers (1)
- What is 'Worksheet formatting?'(Solved)
Define 'Worksheet formatting'
Date posted: April 10, 2018. Answers (1)
- What are the possible causes of the #VALUE! error?(Solved)
Explain the possible cause of the #VALUE! error.
Date posted: April 10, 2018. Answers (1)
- How can you clear as well as edit a cell's content in Excel?(Solved)
Explain how you can clear as well as edit a cell's content in Excel.
Date posted: April 10, 2018. Answers (1)
- What activities would you undertake while editing a worksheet or a worksheet item?(Solved)
Discuss activities you may undertake while editing a worksheet or a worksheet item.
Date posted: April 10, 2018. Answers (1)
- What does editing a worksheet mean?(Solved)
Explain the meaning of editing a worksheet.
Date posted: April 10, 2018. Answers (1)
- List 10 commands that can be used to edit a text(Solved)
List 10 commands that can be used to edit a text
Date posted: April 10, 2018. Answers (1)
- What is 'Relative cell reference?'(Solved)
Explain the meaning of 'Relative cell reference'
Date posted: April 9, 2018. Answers (1)
- What is 'Absolute cell reference?'(Solved)
Define 'Absolute cell reference'
Date posted: April 9, 2018. Answers (1)