Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am trying to make a chart that represents our company's order forecast. I want the chart to be a pivot chart so that it automatically updates. I have a pretty in depth table that will be driving the chart, but the main two pieces of information that I will take from each record are quantity and ship date. What I want the table to display is the total number of pieces we are supposed to ship each week. Additionally the values that are charted will need to be filtered based on weather they have already shipped and what type of unit they are. A starting point would be hugely helpful, or if someone could just point me towards some resources that would be great too. Thanks.

share|improve this question
1  
pretty hard to do much with no idea how your pretty in depth table is structured –  datatoo Feb 3 '12 at 23:09
add comment

1 Answer

Start with learning the basics of Pivots in Excel, for that I would suggest:

PivotTable II: Filter PivotTable report data in Excel 2007

PivotTable III: Calculate data in PivotTable reports in Excel 2007

As well for calculating a week number from a date look at the WEEKNUM() function.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.