Excel Problem. Objective: Practice graph design principles.

Required
Use the data in Table 16-3 to create the following graphs:
a. Sales
b. Sales and Gross Margin
c. Earnings per Share
Which principles of graph design, if any, did you have to manually implement to over-ride the default graphs created byExcel?

Transcribed Image Text:

TABLE 16-3 Data for Problem 16-8 2011 2012 598,000 640,000 575,000 560,000 530,000 248,000 240,000 200,000 230,000 230,000 2014 2013 2010 Sales Cost of Goods Sold 350,000 400,000 375,000 330,000 300,000 Gross Margin Earnings Per Share 12.52 12.10 11.95 11.66 10.50