CLAIT (level 1): Spreadsheets & Graphs

Exercise 6 – Charts Provided by David G Edwards

Before you start this exercise create a folder called GRAPHS on your floppy disk to store your work

Chart 1

Open a new workbook in Microsoft Excel

In the workbook Sheet1 enter the following data about sales of petrol

Month	Value £
Jan	12000
Feb	20000
Mar	22000
Apr	25000
May	15000
June	10000

Create a bar chart showing the sales figures for the period Jan to June

Name the x-axis MONTHS, name the y-axis VALUE £ and give the chart the title MONTHLY SALES – NORTH

Print one copy of the chart and save the workbook as Chart 1 in the folder GRAPHS

Chart 2

Open a new workbook in Microsoft Excel

In the workbook Sheet1 enter the following data showing the monthly sales of shoes

Month	Value
JAN	8750
FEB	12500
MAR	23000
APR	28000
MAY	20000
JUNE	18000

Create a line graph showing the sales figures given

Name the x-axis MONTHS, name the y-axis VALUE £ and give the chart the title MONTHLY SALES

Save as Chart 2 in the folder GRAPHS and print one copy of the chart

Chart 3

Open a new workbook in Microsoft Excel

In the workbook Sheet1 enter the following data showing the numbers of participants on courses

Course No.	No. of Participants
1	16
2	25
3	15
4	28
5	20
6	19

Create a column chart showing the numbers of participants

Name the category axis Course No and the value axis No of Participants

Give the chart the title PARTICIPANTS PER COURSE

Save the workbook as Chart 3 in the sub-folder GRAPHS and print a copy of the chart

Chart 4

You should produce a pie chart showing the sales figures shown below

AREA	SALES
North	18
South	22
Midlands	33
Scotland	27

Give the chart the title Area Sales Percentages - 1^st Quarter

The category name must be displayed for each segment

A percentage figure of each segment must be shown.

A legend must not be displayed.

Save as the workbook as Chart 4 in the folder GRAPHS and print one copy of the chart

Chart 5

Create a comparative line chart with the title DRINKS CONSUMPTION

Enter the following data

DAY	TEA USED	COFFEE USED
MON	75	106
TUE	65	66
WED	75	80
THUR	119	144
FRI	201	250
SAT	260	189

Show a legend to distinguish between TEA USED and COFFEE USED

Name Series 1 as Tea Used

Name Series 2 as Coffee Used

Enter the category axis title as DAY

Name the value axis title as NUMBER OF CUPS

Set the value axis range from 50 to 300

Save as Chart 5 in the sub-folder GRAPHS and print one copy of the graph