Need help in analyzing daily orders grouped in months for order linearity or distrobution

I am analyzing sales orders distribution per partner per month and per year to establish 2 things:

1) Are they putting in orders only on the last week of the month and if yes,
2) How much of the monthly orders are coming from the last week of every month.

I intend to put this in a stacked chart where each month is a total of 100% and the last week's order value as a % of the 100.

Attach is an example of an excel table I have extracted but I am unable to do what I intend to do.

Perhaps some may classify this a Distribution of the orders per partner per month to see order trend.

Is there any kind soul who can Guide me?

Regards
Arnold

Welcome to the forum. In case you did not take the time to read the forum rules, I urge you to do so now. Now, you may not be aware that this site has contributors from all over this world. In some cases, you may post while many are sleeping or working. It is important to understand that all contributors are volunteers here and post as they have time and a willingness. As such, we ask that you not bump your thread until 24 hours has passed. Continually, bumping your thread early will lead users to believe that you are in a discussion with another participant. Many users look for threads that have zero responses in the first 24 hours. As you can see, your early bumping may have hindered the opportunity to receive a timely response. Good luck with your project.

I am not very skilled with pivot tables or advanced tools like power pivot. Recognizing my lack of skill I would be tempted to still use a pivot table.

0) I don't know how valuable this would be, but I notice that your "dates" are really text strings in a non-Excel-standard format. I am not really familiar with all of the ways that pivot tables can make good use of Excel's built in date.time serial numbers, but there could be significant value in changing your date numbers to Excel recognized date.time serial numbers (here if you are unfamiliar with how Excel stores dates.times: http://www.cpearson.com/Excel/datetime.htm )
1) I would add a "week of month" column to the source data (unless converting your date text to serial numbers allows Excel to group by "week of month"). I don't know exactly how you would want to define or calculate "week of month"; I will assume you know that already.
2) Edit existing pivot table or create new pivot table to count # of orders by "week of month".
3) Insert 100% stacked bar/column chart based on the pivot table.

Does that help?