90.2K

Verified Solution

Link Copied!

Need help with the graph

3. The final chart the CEO would like to see a chart which indicates what percentage of US sales occurred each quarter for 2022. This will require that you consolidate the data. Place the consolidated data necessary for this chart in a different area of the original worksheet. Use the same column titles but this new table will only have 8 rows (one row for each quarter of each year). Be sure to follow the charting checklist for the type of chart you selected to complete this task. This is in canvas in the module for the charting class. \begin{tabular}{|r|r|r|r|r|r|r|} \hline Month & US Sales & Other Sales & Total Sales & Sales & Goods Sold & Gross Profit \\ \hline Jan-21 & $6,989,238 & $199,693 & $7,188,931 & $6,829,484 & $3,235,019 & $3,953,912 \\ \hline Feb-21 & $7,729,650 & $220,847 & $7,950,497 & $7,234,952 & $3,577,724 & $4,372,773 \\ \hline Mar-21 & $6,038,549 & $172,530 & $6,211,079 & $6,335,301 & $2,794,986 & $3,416,093 \\ \hline Apr-21 & $5,484,312 & $365,621 & $5,849,933 & $5,876,257 & $2,632,470 & $3,217,463 \\ May-21 & $8,551,452 & $244,327 & $8,795,779 & $8,268,032 & $3,958,101 & $4,837,678 \\ \hline Jun-21 & $8,238,174 & $235,376 & $8,473,550 & $8,261,712 & $3,813,098 & $4,660,452 \\ \hline Jul-21 & $8,831,025 & $252,315 & $9,083,340 & $9,265,007 & $4,087,503 & $4,995,837 \\ \hline Aug-21 & $6,924,096 & $197,831 & $7,121,927 & $6,409,735 & $3,204,867 & $3,917,060 \\ \hline Sep-21 & $13,085,376 & $654,269 & $13,739,645 & $14,770,118 & $6,182,840 & $7,556,805 \\ \hline Oct-21 & $8,230,572 & $235,159 & $8,465,731 & $7,195,872 & $3,809,579 & $4,656,152 \\ \hline Nov-21 & $12,352,014 & $352,915 & $12,704,929 & $12,692,224 & $5,717,218 & $6,987,711 \\ \hline Dec-21 & $8,246,180 & $235,605 & $8,481,785 & $8,142,514 & $3,816,803 & $4,664,982 \\ \hline Jan-22 & $12,531,645 & $358,047 & $12,889,692 & $13,405,280 & $5,800,361 & $7,089,331 \\ \hline Feb-22 & $11,636,328 & $332,467 & $11,968,795 & $12,208,170 & $5,385,958 & $6,582,837 \\ \hline Mar-22 & $14,015,464 & $700,773 & $14,716,237 & $15,084,143 & $6,622,307 & $8,093,930 \\ \hline Apr-22 & $19,252,800 & $550,080 & $19,802,880 & $18,416,678 & $8,911,296 & $10,891,584 \\ \hline May-22 & $19,362,725 & $553,221 & $19,915,946 & $17,924,351 & $8,962,176 & $10,953,770 \\ \hline Jun-22 & $12,495,600 & $357,017 & $12,852,617 & $12,209,986 & $5,783,678 & $7,068,939 \\ \hline Jul-22 & $19,798,587 & $565,674 & $20,364,261 & $20,567,904 & $9,163,917 & $11,200,344 \\ \hline Aug-22 & $17,511,312 & $500,323 & $18,011,635 & $17,381,228 & $8,105,236 & $9,906,399 \\ \hline Sep-22 & $19,019,657 & $766,101 & $19,785,758 & $18,796,470 & $10,342,364 & $9,443,394 \\ \hline Oct-22 & $14,804,280 & $422,979 & $15,227,259 & $14,770,442 & $6,852,267 & $8,374,992 \\ \hline Nov-22 & $17,176,170 & $490,748 & $17,666,918 & $17,843,587 & $7,950,113 & $9,716,805 \\ \hline Dec-22 & $16,480,000 & $459,870 & $16,939,870 & $17,363,367 & $8,104,500 & $8,835,370 \\ \hline Tala & $294,785,206 & $9,423,788 & $304,208,994 & $313,632,782 & $138,814,378 & $165,394,613 \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer