Can you please show me the formatting and the steps:

1. The CEO knows that US sales are much higher than sales outside the US but she wants to see if they are in sync with each other on a monthly basis. So, for example, she wants the chart to visibly show her whether a large increase in US sales from one month to another also resulted in a large increase in sales outside the US. Show the entire 24-month period on the x-axis. Given the large difference in sales it may be necessary to use two separate axes. The axis which contains the US sales results should be in millions and the numbers should be custom formatted so that values appear as $1.5m and the outside US sales axis should be in thousands and custom formatted to appear as $200k. (NOTE: you will be graded on these custom formats and they must EXACTLY match the examples provided above). Given this format, carefully consider any axis labels that may or may not be necessary. You may need to use Excels help or Google to create this custom number format. Name this sheet Chart1.
2. The second chart the CEO would like to see is a chart for each month of 2017 (only) which shows total monthly sales in comparison to budgeted monthly sales. Be sure to follow the rules for every chart document provided in class. Given the many formatting options available, Name this sheet Chart 2.
3. The final chart the CEO would like to see a pie chart which indicates what percentage of US sales occurred each quarter for 2017. This will require that you prepare the data in a different manner. Make an exact duplicate copy of the sheet that contains the original data and then re-state the data into quarters so that you can create the chart. Delete any data from this sheet that is no longer necessary. Place all labels outside of the pie and italicize the text. Rotate the pie so that 3rd quarter sales are at the 4:00 position (as if on a clock) of the pie and fill the slice of the quarter with the smallest percent of sales with a pattem.

Budgeted Total Sales Cost of Goods uS Sales Other sales TotlSsaes Gross Profit 6989238 199692.5143 7188930 514 6829483 989 3235018.731 3953911.783 7729650. 2208471429 7950497.143. 72349524 3577723, 14: 4372773429 6038549 172529 9714 6211078.971 6335300 551 2794985 537 3416093434 5484312 8551452 8238174 8831025 Mar-16 365620.8 58499328 5876257 498 2 244327.28795779.2 8268032448 39581 235376.4 84735504 826171164 2632469.76 3217463.04 4837678 56 3813097.68 4660452.72 Jun-16 Jul-16 252315 90833409265006.8 4087503 4995837 Aug-16 6924096 197831 3143 5421927314 6409734583 3204867 291 3917060.023 13085376 654268.8137396448 14770118.166182840.16 Oct-16 Nov-16 12352014 352914.6857 12704928.69 12692223.76 5717217 909 6987710.777 Dec-16 Jan-17 8230572 235159.2 8465731.2 719587152 3809579.04 4656152.16 8246180 235605.1429 8481785.143 8142513.737 3816803.314 4664981 829 358047 12531645 11636328 332466.5143 1196879451 12208170.4 5385957531 6582836983 14015464 19252800 12889692 13405279.68 5800361.4 7089330.6 700773.2 14716237.215084143.13 6622306.74 8093930.46 55008019802880 184166784 8911296 19362725 553220.7143 19915945.71 17924351.148962175.571 10953770.14 Jun-17 12495600 357017.1429 12852617.14 12209986.295783677.714 7068939.429 19798587 565673.9143 20364260.9120567903.52 9163917.41111200343.5 17511312 500323.2 18011635.2 17381227.97 8105235.84 9906399.3 10342363.5 9443394.9 Sep-17 19019657.4 Oct-17 766101 19785758.4 18796470.48 14804280 422979.4286 15227259.43 14770441.656852266.743 8374992.686 17176170 490747.7143 17666917.7117843586.897950112.971 9716804.743 16939870 17363366.75 459870 8104500 8835370 16480000 294785206.4 9423788 304208994.4 313632782.4 1388143782 165394616 Budgeted Total Sales Cost of Goods uS Sales Other sales TotlSsaes Gross Profit 6989238 199692.5143 7188930 514 6829483 989 3235018.731 3953911.783 7729650. 2208471429 7950497.143. 72349524 3577723, 14: 4372773429 6038549 172529 9714 6211078.971 6335300 551 2794985 537 3416093434 5484312 8551452 8238174 8831025 Mar-16 365620.8 58499328 5876257 498 2 244327.28795779.2 8268032448 39581 235376.4 84735504 826171164 2632469.76 3217463.04 4837678 56 3813097.68 4660452.72 Jun-16 Jul-16 252315 90833409265006.8 4087503 4995837 Aug-16 6924096 197831 3143 5421927314 6409734583 3204867 291 3917060.023 13085376 654268.8137396448 14770118.166182840.16 Oct-16 Nov-16 12352014 352914.6857 12704928.69 12692223.76 5717217 909 6987710.777 Dec-16 Jan-17 8230572 235159.2 8465731.2 719587152 3809579.04 4656152.16 8246180 235605.1429 8481785.143 8142513.737 3816803.314 4664981 829 358047 12531645 11636328 332466.5143 1196879451 12208170.4 5385957531 6582836983 14015464 19252800 12889692 13405279.68 5800361.4 7089330.6 700773.2 14716237.215084143.13 6622306.74 8093930.46 55008019802880 184166784 8911296 19362725 553220.7143 19915945.71 17924351.148962175.571 10953770.14 Jun-17 12495600 357017.1429 12852617.14 12209986.295783677.714 7068939.429 19798587 565673.9143 20364260.9120567903.52 9163917.41111200343.5 17511312 500323.2 18011635.2 17381227.97 8105235.84 9906399.3 10342363.5 9443394.9 Sep-17 19019657.4 Oct-17 766101 19785758.4 18796470.48 14804280 422979.4286 15227259.43 14770441.656852266.743 8374992.686 17176170 490747.7143 17666917.7117843586.897950112.971 9716804.743 16939870 17363366.75 459870 8104500 8835370 16480000 294785206.4 9423788 304208994.4 313632782.4 1388143782 165394616