Column Chart With Week numbers

[umair434]

Hi all,

I am trying to create a column/bar chart for some raw data that I have.

Data:

Products, Zones, Ordering Coming date

So, the data I have is for products that are in some zones (warehouses), and orders coming date is when the orders are coming (sample sheet attached).

What I would like is: a chart that shows how many orders are coming in each month from now.


Product Warehouse Incoming Orders
Hoodies A Wk40-13
Hoodies B Wk43-13
Boots A Wk48-13
Boots B Wk02-14
Boots C Wk03-14
Caps A Wk45-13


Any suggestions?

I have tried percentrank, but that causes the first week numbers to be zero. I also tried countif to calculate number of products for each week, get their ratio and then plot, but Im wondering if there's more effective way?

 

[Rx_]

The Date in Excel is actually the number of days since the year 1900.
Of course, that number of days can be presented in many ways using the Format.
If you convert the WK40 of 2013 to the date system, date formulas work so much easier.
Then you can have a range of some date +7 or some date +28 to manage the number of weeks.