Page 38 - DCAP101_BASIC_COMPUTER_SKILLS

Unit 2: Introduction to Data Representations

(a) The Data Range dialog box is fairly self-explanatory. Notice the “Series in: Column” Notes
button is marked. Also notice the “=Sibling!” in the Data Range box; this indicates
what worksheet the data is on. We don’t really need it in this example but it is
necessary when we are working with more than one worksheet in an Excel
workbook.

Data Range Series

Class sizes
45
Humber of Students 30 Students
40
35
25
20
15
10
0 5
English Biology Calculus Physics History
Courses

Data range: =Sheet2!$1:$B$6
Series in: Rows
l
Co umns
B
Cancel < ack Next > Finish

(b) Now click the “Series” tab at the top. This is where we set up some of the
X-axis format. “Series 1” refers to the data and is associated with both the chart
legend and title. We’ll give it a name here just to try it out (we’ll modify it later
however). Type “Siblings” in the empty Name space. You’re done in that box
(don’t hit enter yet or you’ll go to step 3).

Source Data
Data Range Series
300
250
200
Monthly
150
Smoothed
100
50
0
1749 1766 1781 1800 1817 1834 1851 1867 1884 1901 1916 1915 1952 1969 1986 2003
Series
Monthly Name: Smoothed
Smoothed

Values: =MonSunspot!$D$9:$D$3081
Add Remove

Ca egory (X) axis labels: =MonSunspot!$D$9:$B$3081
t

B
Cancel < ack Next > Finish
Contd...

LOVELY PROFESSIONAL UNIVERSITY 31