B04 Create and Edit Charts 3:36
prev < Numbers ’09 > next
1
00:00:01,201 --> 00:00:03,870
Create and edit charts
2
00:00:05,205 --> 00:00:07,941
Relationships in your data are easy to spot
3
00:00:07,941 --> 00:00:09,576
when you display it with a chart.
4
00:00:11,811 --> 00:00:14,414
**This table ... Utility Costs**
5
00:00:14,414 --> 00:00:16,383
over the course of two years.
6
00:00:16,383 --> 00:00:19,619
Lets show some of the data
in this table as a chart.
7
00:00:19,619 --> 00:00:22,856
First we'll select the row for 2007,
8
00:00:22,856 --> 00:00:24,557
next would choose the chart type
9
00:00:24,557 --> 00:00:26,659
by clicking the "Charts" button in the toolbar.
10
00:00:27,727 --> 00:00:29,996
Two dimensional chart are listed on the left
11
00:00:29,996 --> 00:00:33,299
and three dimesional chart are on the right.
12
00:00:33,299 --> 00:00:35,135
Lets choose a 2D bar chart.
13
00:00:36,603 --> 00:00:39,939
In our chart we don't want have
the total cost represented,
14
00:00:39,939 --> 00:00:42,842
**is a ... comprising between**
the month less meaningful.
15
00:00:43,910 --> 00:00:45,979
To remove this data point from the chart
16
00:00:45,979 --> 00:00:47,614
but keeping it in our table
17
00:00:47,614 --> 00:00:49,315
click once in the total column
18
00:00:49,315 --> 00:00:51,418
and then press delete on your keyboard.
19
00:00:52,786 --> 00:00:54,854
Now the chart more clearly represents
20
00:00:54,854 --> 00:00:57,390
the relative cost of the individual month.
21
00:00:58,324 --> 00:01:00,160
It's fast and easy to view the data
22
00:01:00,160 --> 00:01:02,929
plotted it in a chart in different ways
23
00:01:02,929 --> 00:01:05,698
For example to see the difference
between the cost
24
00:01:05,698 --> 00:01:08,234
for 2007 and 2008
25
00:01:08,234 --> 00:01:09,469
select the chart
26
00:01:09,469 --> 00:01:11,771
then go to the selected row in the table
27
00:01:11,771 --> 00:01:14,340
and drag it down over the 2008 row.
28
00:01:15,842 --> 00:01:19,179
The chart dynamically update
as you move your highlighted row
29
00:01:19,179 --> 00:01:21,915
allow you to quickly visualize the relationship
30
00:01:21,915 --> 00:01:23,383
between the two years.
31
00:01:24,517 --> 00:01:27,320
Now let add data for 2008 to the chart.
32
00:01:28,154 --> 00:01:30,423
Shift click on the december cell
33
00:01:30,457 --> 00:01:32,192
and the january cell
34
00:01:32,192 --> 00:01:34,394
to show the data for that year.
35
00:01:34,394 --> 00:01:37,097
Next click and hold on the highlighted row
36
00:01:37,097 --> 00:01:40,266
and drag it to the chart until
the green plus sign appears
37
00:01:40,266 --> 00:01:42,302
and then release the mouse.
38
00:01:42,302 --> 00:01:45,939
The corresponding data for 2008 appears.
39
00:01:45,939 --> 00:01:47,340
With the chart selected
40
00:01:47,373 --> 00:01:50,443
most of the controls you need
to change the chart colors,
41
00:01:50,443 --> 00:01:53,913
labels and other elements
are right in the format bar.
42
00:01:53,913 --> 00:01:56,683
To add titles go to the chart options menu
43
00:01:56,683 --> 00:01:58,985
and select "Show Titles".
44
00:01:58,985 --> 00:02:01,354
Select the title type in your label.
45
00:02:09,195 --> 00:02:12,198
You can also tilt the x axis labels.
46
00:02:12,198 --> 00:02:14,033
Click on one them once to select them,
47
00:02:14,033 --> 00:02:16,636
then go to the "Angle" menu in the format bar
48
00:02:16,636 --> 00:02:18,471
and pull down to 30 degrees.
49
00:02:20,106 --> 00:02:23,276
Now lets change some of the chart colors,
50
00:02:23,276 --> 00:02:25,912
One fast and easy way
to change the chart color
51
00:02:25,912 --> 00:02:28,715
is to click on "Chart Colors..."
button in the format bar
52
00:02:30,383 --> 00:02:33,253
Here you'll find a number
of professionally selected
53
00:02:33,253 --> 00:02:36,156
color sets that work well together.
54
00:02:36,156 --> 00:02:38,191
For example, form the top menu
55
00:02:38,191 --> 00:02:40,860
pull down to "2D Colors Fills",
56
00:02:40,860 --> 00:02:42,529
click on one of the blue tiles
57
00:02:42,529 --> 00:02:45,231
and drag it over a chart element,
**then like go.**
58
00:02:46,065 --> 00:02:48,434
All of the data points in the same series
59
00:02:48,434 --> 00:02:50,203
are change to that color.
60
00:02:50,203 --> 00:02:52,205
You can also set a group of data points
61
00:02:52,205 --> 00:02:54,307
to follow a set color pattern.
62
00:02:54,307 --> 00:02:56,943
Select "Spectrum" from the pull down menu
63
00:02:56,943 --> 00:02:59,579
and then click to the "Apply All" button.
64
00:02:59,579 --> 00:03:01,114
The first two colors is in the set
65
00:03:01,114 --> 00:03:03,516
are applied to your entire chart.
66
00:03:03,516 --> 00:03:06,052
You can also instantly change the chart type
67
00:03:06,052 --> 00:03:09,055
to find other compelling ways
to display your data.
68
00:03:09,055 --> 00:03:11,724
For example, with the chart selected,
69
00:03:11,724 --> 00:03:15,528
go to the format bar and click on
the "Chart" pop-up menu.
70
00:03:15,528 --> 00:03:19,232
Here you'll see all of the
2D and 3D chart types listed,
71
00:03:19,232 --> 00:03:21,801
lets choose "3D Area".
72
00:03:21,801 --> 00:03:23,803
Your chart updates to a 3D version
73
00:03:23,803 --> 00:03:26,673
which you can rotate for the look you like best.
74
00:03:26,706 --> 00:03:28,575
Numbers give you many flexible ways
75
00:03:28,575 --> 00:03:32,478
to easily visualize and present
your data using charts.
page revision: 8, last edited: 03 Oct 2009 22:03
B04 Create and Edit Charts
Transcribing, timecoding and translating to italian in progress.
MacTutorial Subtitles, Wik-iPad, HTML5 App, FreeSMUG
Need transcription help at 12", 40" and 2'43"
Thanks.
MacTutorial Subtitles, Wik-iPad, HTML5 App, FreeSMUG