Genre January February March April May
Classics $18,580 $49,225 $16,326 $10,017 $26,134
Mystery $78,970 $82,262 $48,640 $49,985 $73,428
Romance $24,236 $131,390 $79,022 $71,009 $81,474
Sci-Fi & Fantasy $16,730 $19,730 $12,109 $11,355 $17,686 $140,000
Young Adult $35,358 $42,685 $20,893 $16,065 $21,388
$120,000
LESSON: MAKING CHARTS
$100,000
*To make a chart, highlight everything together
*Go to Insert tab, then click "Recommended Charts"
$ SOLD AMOUNT
$80,000
Types of topic that will be covered, will only be:
1)Bar Chart
$60,000
2)Pie Chart
3)Line Chart
$40,000
4)Bubble Chart/Scatter
*In Chart Design tab, you can:
$20,000
1)Change style of the chart in the Chart Style section
2)Change colour - using Change Colours icon.
$0
NOTE: If you only want to change one color, go to Home tab then
click Fill Color
3)You change the layout of the chart using Quick Layout under Chart Layout section
4)You can use Add Chart Elements under Chart Layout section to add titles, labels, etc
5)Change your chart type using the Change Chart Type under Type section.
EX: Bar chart to Pie chart without starting from scratch
6)You can move your chart to a different sheet using the Move Chart under Location section
7)You can remove a coloumn/row, change names,etc using Select Data under Data section
8)You can switch row/coloumn using Switch Row/Column under Data section
$140,000
$120,000
$100,000
$ SOLD AMOUNT
$80,000
$60,000
$40,000
$20,000
$0
January February March April May
MONTH
Classics Mystery Romance Sci-Fi & Fantasy Young Adult
$140,000
$120,000
$100,000
$80,000
Axis Title
$60,000
$40,000
$20,000
$0
January February March April May
Axis Title
Classics Mystery Romance Sci-Fi & Fantasy Young Adult
Circle City Sporting Goods
Department January February March Dept. Totals
Athletic Apparel $135,202.56 $173,538.77 $51,552.99 $360,294.32
Exercise Equipment $109,141.06 $145,219.36 $72,074.22 $326,434.64
Footwear $47,924.66 $43,132.20 $38,339.73 $129,396.59
Camping Gear $78,130.28 $83,699.02 $88,045.57 $249,874.87
Football $102,466.88 $63,705.49 $137,926.10 $304,098.47
Baseball $74,849.81 $125,634.90 $46,936.17 $247,420.88
Soccer $167,349.29 $50,926.39 $111,380.65 $329,656.33
Basketball $125,452.32 $89,454.12 $95,124.15 $310,030.59
Monthly Tools $840,516.86 $775,310.25 $641,379.58 $2,257,206.69
LESSON 2: MAKING SPARKLINES
*In Insert tab, then choose the type of sparkline you want under Sparklines section
Line sparkline will be use for this example:
Step 1: Click the Line icon under Sparklines section
Step 2: Choose the Data Range that you want by highlighting. (EX- B3:D3)
Step 3: Choose the Location range by highlighting. (EX: Highlight F3 cell - to place your line)
Step 4: You can drag it down to apply for everything
*In Sparkline tab, you can:
1)Change the colour under Style section
2)You can show the high,low,negative point using it under the Show section
3)You can use the Marker color under the Style section to change color of your points
Column sparkline will be use for this example:
*In Insert tab, then choose the type of sparkline you want under Sparklines section
Step 1: Click the Line icon under Column section
Step 2: Choose the Data Range that you want by highlighting. (EX- B3:D3)
Step 3: Choose the Location range by highlighting. (EX: Highlight G3 cell - to place your column)
Step 4: You can drag it down to apply for everything
*In Sparkline tab, you can:
1)Change the colour under Style section
2)You can show the high,low,negative point using it under the Show section
3)You can use the Marker color under the Style section to change color of your points
NOTE: Make sure all automatic for the vertical minimum/maximum value is checked in the Axis icon under the Group section in
LINE SPARKLINE COLUMN SPARKLINE
NG SPARKLINES
place your line)
place your column)
checked in the Axis icon under the Group section in Sparkline tab
