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.
All videos are copyright by Apple Inc.; transcriptions, subtitles and translations are volunteer efforts by members of this wiki.