Tools for Information Literacy

Create a chart that compares multiple columns of data by the values in a separate column

Create a data source

Still using your downloaded workbook ...

Use the data on the 15-Chart 01 worksheet

back to top

Prepare the data

1. Using the data on the 15-Chart 01 worksheet, create a chart to display the Food grain demand, Other grain demand, Total grain demand, Grain production, and Implied additional supply required for the year 2031 for any Sub-Region you are interested in

back to top

Generate the chart

2. Use a chart that compares values (Millions of metric tons) to categories (Element).
3. 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.
4. Name the standalone chart 15.Food Demand

You may use the chart wizard, but do not use the defaults. Modify it to make it yours.

back to top

Demonstrate facility with the chart formatting tools

8. 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.
9. Include a chart title and modify the display in some fashion to make it unique to your style.

back to top