ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
GenreJanuaryFebruaryMarchAprilMay
2
Classics$18,580$49,225$16,326$10,017$26,134
3
Mystery$78,970$82,262$48,640$49,985$73,428
4
Romance$24,236$131,390$79,022$71,009$81,474
5
Sci-Fi & Fantasy
$16,730$19,730$12,109$11,355$17,686
6
Young Adult$35,358$42,685$20,893$16,065$21,388
7
8
9
10
Select cells A1:F6 and insert a chart.
11
Change the chart type to column and the style to 3D
12
Look at the chart and the data then change the chart title to something that reflects the information.
13
Use the editor to change the colors of the data columns in your charts.
14
Use the editor to add a vertical and horizontal axis title and the units in ( )
15
Move the chart to it's own sheet.. Then name the new sheet tab.
16
17
Select cells A1:F6 and insert a chart.
18
Change the chart type to bar and the style to 3D
19
Use the Switch Row/Column command. as needed so the Inependent data is grouped by Genre.
20
Look at the chart and the data then change the chart title to something that reflects the information.
21
Use the editor to add a vertical and horizontal axis title and the units in ( )
22
Use the editor to chage the colors of the data columns in your charts.
23
Move the chart to it's own sheet.. Then name the new sheet tab.
24
25
Select cells A1:F6 and insert a chart.
26
Change the chart type to line chart.
27
Use the Switch Row/Column command. as needed so the Inependent data is grouped by Month.
28
Use the editor to add a vertical and horizontal axis title and the units in ( )
29
Use the editor to chage the colors of the lines in your chart.
30
Look at the chart and the data then change the chart title to something that reflects the information.
31
Move the chart to it's own sheet.. Then name the new sheet tab.
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100