Please, how do i Prepare 3 pie charts (one each for segment revenue, profits and assets), showing the average percentage (over the 10 years) that each segment contributes to total company revenue, profits and the allocation of assets. The pie chart should be properly labeled and the use of colors to indicate the segments is encouraged. The formulas for calculation of the contribution by each segment to segment revenue, profits and assets should be in the spreadsheet.

Here is the Info,

Year Ended Segment Name SALES ASSETS PROFIT 12/31/2007 Doc 42688 57670 7883 12/31/2008 Doc 41233 51863 7460 12/31/2009 Doc 18494 20377 3923 12/31/2010 Doc 17464 21175 3304 12/31/2011 Doc 18442 23567 3512 12/31/2012 Doc 19322 25144 3747 12/31/2013 Doc 21411 32272 4345 12/31/2014 Doc 23298 33716 4973 12/31/2015 Doc 24242 34524 5507 12/31/2016 Doc 25530 38899 6115 12/31/2007 Sleepy 30347 31466 4817 12/31/2008 Sleepy 41948 36973 6497 12/31/2009 Sleepy 40015 36663 7105 12/31/2010 Sleepy 37198 38606 7271 12/31/2011 Sleepy 43369 54389 6650 12/31/2012 Sleepy 6925 9253 131 12/31/2013 Sleepy 6721 9962 110 12/31/2014 Sleepy 14812 15536 677 12/31/2015 Sleepy 15329 21587 944 12/31/2016 Sleepy 14074 17858 311 12/31/2007 Grumpy 33219 310412 12243 12/31/2008 Grumpy 65937 627501 8063 12/31/2009 Grumpy 47437 597877 1325 12/31/2010 Grumpy 45214 565337 3158 12/31/2011 Grumpy 44658 552514 6549 12/31/2012 Grumpy 44327 539351 7401 12/31/2013 Grumpy 42917 516829 8258 12/31/2014 Grumpy 10283 502204 1209 12/31/2015 Grumpy 9650 316069 -7983 12/31/2016 Grumpy 9617 187804 -1251 12/31/2007 Sneezy 13343 25303 2039 12/31/2008 Sneezy 14442 26515 2240 12/31/2009 Sneezy 15975 27163 2420 12/31/2010 Sneezy 16867 27784 2741 12/31/2011 Sneezy 18018 27981 2803 12/31/2012 Sneezy 18253 28458 2920 12/31/2013 Sneezy 18186 27956 3048 12/31/2014 Sneezy 18293 29227 3047 12/31/2015 Sneezy 17632 28162 2882 12/31/2016 Sneezy 18276 28639 3161 12/31/2007 Happy 12520 5351 1034 12/31/2008 Happy 10049 4908 365 12/31/2009 Happy 8410 4955 370 12/31/2010 Happy 8599 4280 457 12/31/2011 Happy 8407 4645 300 12/31/2012 Happy 7944 4133 311 12/31/2013 Happy 8313 4237 381 12/31/2014 Happy 8425 4340 387 12/31/2015 Happy 8840 4432 395 12/31/2016 Happy 9653 4495 414 12/31/2007 Bashful 8134 8045 1100 12/31/2008 Bashful 8542 8132 1245 12/31/2009 Bashful 9043 9005 1394 12/31/2010 Bashful 9227 9340 1406 12/31/2011 Bashful 13306 18855 1660 12/31/2012 Bashful 14927 20099 1924 12/31/2013 Bashful 16970 26250 2357 12/31/2014 Bashful 18683 27329 2758 12/31/2015 Bashful 16063 26126 2427 12/31/2016 Bashful 12515 24615 1392 12/31/2007 Dopey 9022 8794 576 12/31/2008 Dopey 6385 3572 694 12/31/2009 Dopey 6261 8726 431 12/31/2010 Dopey 10040 9423 845 12/31/2011 Dopey 12300 11045 1345 12/31/2012 Dopey 27180 27174 5422 12/31/2013 Dopey 23777 29526 4992 12/31/2014 Dopey 19802 26698 4486 12/31/2015 Dopey 20728 51674 4502 12/31/2016 Dopey 26187 55474 4979