Excel Charting Exercises - Earl Haig



Excel Charting Exercises

Exercise 1

1. Use a column chart to graph Year 1 and Year 2 Sales

2. Use an appropriate title

3. Customize the colours

4. Insert it as a new chart called “Chart Exercise 1”

Exercise 2

1. Use a column chart to graph the exam result for each student. Each student should have 3 result displayed.

2. Use an appropriate title

3. Customize the colours

4. “Column Chart Exercise 2”

Exercise 3

1. Use excel to calculate the total points scored for each player.

2. Use a column chart to graph the total points scored for each student.

3. Use a pie chart to compare how many points each student scored.

4. Use an appropriate title for each chart

5. Customize the colours

6. “Column Chart Exercise 3”

7. “Pie Chart Exercise 3”

Exercise 5

1. Use a column chart to graph the Total December sales for each salesperson

2. Use a pie chart to compare sales for the various salespeople.

3. Use an appropriate title for each chart

4. Customize the colours

5.“Column Chart Exercise 5”

6. “Pie Chart Exercise 5”

Exercise 6

1. Use a column chart to chart each students Average

2. Use an appropriate title for each chart

3. Customize the colours

4. “Column Chart Exercise 6”

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download