Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .