This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 6. Add a series a. Ensure that D2:D3 are the X axis b. Ensure that E2:E3 are the Y axis c. Do not name the series at all - leave it blank 7. Insert a Chart Title, over the chart and make the graph title "Budget Line" 8. Make the Value X axis title below the graph axis say "Qty Brand X" 9. Make the Value Y axis beside the vertical axis of the graph say "Qty Brand Y" 10. Delete the Legend 11. Resize the graph to cell range A4:E13 12. You have $1200.00 to spend and the price of brand X is $60.00 and the price of brand y is $40.00. 13. Input your data to show the correct budget line. Key 9370affde322f57ea133b5ee53f561f4a Student ID 000425711 First Name Matthew Last Name Brown Email email@example.com Assignment E51 Assignment Assignment E51 Excel Activity...
View Full Document
- Spring '10