| Why we do this | What we are to do |
|---|---|
| to create a new workbook from existing worksheets |
Download this workbook from Canvas and use it for this week's spreadsheet tasks.
Then save the downloaded worksbook to a location on your laptop where you will save your task04 work and name the saved/stored workbook with a standard (i.e., lastname_firstname_YYYYMMDD_task04c.xlsx) file name |
Using the data on the 15-Chart 01 worksheet, create a chart to display the Total grain demand and Grain production for the year 2031 for the four sub-regions of Sub-Saharan Africa.
The source data is poorly arrayed in the table, so you will need to filter and perhaps sort the source data to make it useful.
| Why we do this | What we are to do | some thoughts |
|---|---|---|
| to prepare the data |
using the data on the 15-Chart 01 worksheet
select the values for the Total grain demand, and Grain production for the year 2031, for the four sub-regions of Sub-Saharan Africa. |
This will require you to filter selected columns
and perhaps to sort by Sub-Region. |
| to create a chart that compares one data set by category |
Use a chart that compares values (Millions of metric tons) to categories (Element).
You will be creating a clustered column or a clustered bar chart. Place the chart on a separate worksheet (this means the chart stands alone on a worksheet and does not float above a grid of cells on a worksheet) named 15-Food Demand. |
You may use the chart wizard, but do not use the defaults. |
| to demonstrate facility with the chart formatting tools | You will need to work with the chart tools to ensure that the X or Y axes (depending on whether you use a column or a bar chart) are labeled. | Depending on how you build your chart, they may not need labeling. |
| to demonstrate facility with additional chart formatting tools/td> | Include a chart title and modify the display in some fashion to make it unique to your style. | Do not leave it in the program's default look. |