Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need help with graph 3. The final chart the CEO would like to see a chart which indicates what percentage of US sales occurred each
need help with 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} Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started