TEACHING EXCEL FOR DATA ANALYSIS: HANDS ON 25 Modifying and formatting charts

 

Modifying and formatting charts

You have created a chart that illustrates the weekly sales made by your sales staff. You would like to improve the look of the chart. Additionally, it looks as though George Jackson’s data has been accidentally left out of the chart.

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. Click to select the chart on the current worksheet. You will see the Chart Design and Format contextual tabs appear on the ribbon:

3. First, you should add a title to this chart. Click Chart Design → Add Chart Element → Chart Title → Above Chart:

4. The chart title is now displayed above the data series on the chart:

5. Next, you should add gridlines to make this chart a little easier to read. Click to select the chart and then click the Chart Elements button that appears near the top right-hand corner:

6. From the menu that appears, check the Gridlines check box:

7. Major gridlines are now displayed on the chart:

8. Finally, you might as well remove the legend as it is fairly self-evident what this data represents. Click Chart Design → Legend → None:

9. Now you need to adjust the color of this chart. Click the Chart Design contextual tab. Within the Chart Styles gallery, click any of the chart styles presented:

10. The new style is now applied to the selected chart:

11. Finally, with the chart selected, click and drag the handle of the highlighted data selection, at the bottom right of cell E13, and drag it down one row:

12. A column representing the weekly sales of George Jackson will be added to the chart:

13. Save your current workbook as Activity 4-2 Complete and close Microsoft 365 Excel to complete this exercise.

14. Now, you can check out an example of a completed document in the link below:

https://github.com/alcadelina/Excel-