Creating charts
You need to produce a chart that easily demonstrates to your supervisor which salesperson made the most sales in week 1.
1. Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.
https://github.com/alcadelina/Excel-
2. First, you need to select the dataset with which you would like to work. Use your cursor to select cells C4:C14 and E4:E14. Remember to hold the Ctrl key down when selecting non-adjacent cell ranges:
3. Next, click Insert → Insert Column or Bar Chart → Clustered Column:
4. The new chart now appears on the current worksheet, overlapping some of the data:
5. Click and drag this chart to a location on the worksheet where it is not overlapping anything:
6. Examine the new chart. You will quickly see that Thompson made the most sales in week 1, with Harrison as the next runner up. McCain clearly has some work to do:
7. Save the current workbook as Activity 4-1 Complete and then close Microsoft 365 Excel to complete this exercise.
8. Now, you can check out an example of a completed document in the link below:
No comments:
Post a Comment