Data
Display
Chart 15-Food Demand
TASK 04c Mac
INLS 161
Tools for
Information
Literacy
Find 15-Chart Worksheet
Read the Task Requirement and figure out how to filter data
THERE IS A DISCREPANCY WITH THE WEBSITE AND THE GRADE SHEET
Read the Question and Identify the Goal
Food grain demand
Other grain demand
Implied additional supply required
XX Sub-Saharan Africa
Total
2031
Sub-Saharan Africa
using the data on the 15-Chart 01 worksheet
select the values for the ELEMENT
Food grain demand,
Other grain demand,
and Implied additional supply required
for the year 2031,
for the four sub-regions of Sub-Saharan Africa
(this does not include Sub-Saharan Africa, Total).
This will require you to filter column A, B, C, and D,
and to sort by Sub-Region.
Result of Filters
Insert 2-D Clustered Bar
Click anywhere in the data
1
2
3
4
You will get a messy chart!
messy chart
Move the chart before fixing
We will fix the messy chart after we move it.
Right click in a open space without data and choose move chart.
1
2
Name the new chart 15-Food Demand
Find the new chart and Choose select data
right click
select data
Mac
delete all Legend entries by clicking minus. This will remove all data in all the boxes for a blank start
All clean and ready for your custom chart.
Add Legend Series
Click plus four times and add
Series1
Series2
Series3
Series4
Reame each series:
Central Africa
East Africa
Southern Africa
West Africa
the equal sign and quotation marks will be added automatically; you do not need to type them. Just type
Central Africa
don’t delete; just choose new data (step 4)
for each sub-region choose the three numbers in the millions of metric tons (see step 5 below)
1
2
3
select each
4
5
Choose the category values (Element data)
choose the category labels
select all
Refine the Chart
This legend is correct, but it is too small and requires a lot of “back and forth scans” so we are going to put the sub-region label on the bar and remove the legend later.
Add Data labels
click to select chart
1
4
5
choose chart design
2
3
Data labels added
Add Subregions to Data Labels
click to select chart
1
choose format
2
choose format pane
3
choose label
options
4
check on series
name
5
choose Inside
End
6
Subregion Added to end of all West Africa bars
7
Repeat process for all other subregions
Outside End position seems to be best for the remaining subregions
8
Wrap up the Chart Layout
click to select chart
1
choose chart design
2
add chart element
3
remove legend
4
add primary horizontal
5
Final touches
Finalize title
choose chart design you prefer
2
1
Finalize primary horizontal axis title
3
Select any text that is unreadable and go to home tab to adjust.
4