Charts in Excel
Block 3- Q1
| Use the following sales data to develop a stacked bar chart in Excel. Make sure to label the axis and provide the raw data. Also, include a title in the graph. | |||
| Week | James | Smith | Jones |
| 1 | 2653.4 | 3909.1 | 9788 |
| 2 | 3928.8 | 2279.5 | 495.1 |
| 3 | 4237.6 | 1040.7 | 2828.3 |
| 4 | 511.2 | 7537.1 | 3095.2 |
| 5 | 3052.5 | 3367.6 | 42000 |
| 6 | 3202.1 | 5106.2 | 3937.9 |
| 7 | 676.6 | 782.1 | 6774.5 |
Block 3 - Q2
| •Use the following data to develop a scatter plot. | |
| •Add trend lines to the scatter plot. | |
| •Add a moving average trend line. | |
| •Add a linear regression. | |
| •Use the design, layout and format tabs to | |
| make the chart look good. | |
| Date | Items Produced |
| 1/2/11 | 30 |
| 1/3/11 | 33 |
| 1/4/11 | 31 |
| 1/5/11 | 26 |
| 1/6/11 | 23 |
| 1/7/11 | 20 |
| 1/8/11 | 15 |
| 1/9/11 | 15 |
| 1/10/11 | 12 |
| 1/11/11 | 17 |
| 1/12/11 | 20 |
| 1/13/11 | 23 |
| 1/14/11 | 22 |
| 1/15/11 | 17 |
| 1/16/11 | 23 |
| 1/17/11 | 29 |
| 1/18/11 | 29 |
| 1/19/11 | 31 |
| 1/20/11 | 36 |
| 1/21/11 | 37 |
| 1/22/11 | 42 |
| 1/23/11 | 45 |
| 1/24/11 | 44 |
| 1/25/11 | 49 |
| 1/26/11 | 46 |
| 1/27/11 | 44 |
| 1/28/11 | 43 |
| 1/29/11 | 46 |
Block 3 - Q3
| •Graph this function y = exp(x) from 1 to 20 in Excel using a scatter chart. |
| •Covert the axis to a log scale. What does the graph show. |
Read Me
| Please complete the three problems and submit the Excel file to blackboard. |