| Designing Excel Charts |
| (6 pts) Design three different types of charts using the spreadsheet designed from scratch. Each chart must utilize and show different types or ranges of data. (6 pts) Create a title for each chart that explains its subject. Format the text. (6 pts) Include X and Y axis descriptions (avoid abbreviations) that relate to data. This option will not be available on a pie chart; instead explode a minimum of two slices. (5 pts) Include minimum of one set of data labels per chart. The text must clear, accurate and easy to read. Minimum of two different types of data labels (value, text, percent, etc.) must be utilized. (6 pts) Include a legend that identifies all chart data with descriptions that relate to the data. The text must clear, accurate and easy to read. (3 pts) Format the chart colors with different types of patterns--avoid solid color. (3 pts) Embed chart one with spreadsheet in normal view--fit to one page (3 pts) Embed chart two with spreadsheet in formula view--fit to one page (4 pts) Place chart three on a new sheet with a selected area of the spreadsheet which shows the data related to the chart (normal view--fit to one page). (3 pts) Print each chart as listed with student name in footer. |