How do I graph 8 weeks of data automatically. Excluding previous weeks in a pivot.

Sample data would be good.

I suspect easiest way would be to extract the relevant data from the whole set and then graph on the extract rather than the pivot.

Thanks
Rob H

You can use a dynamic range name to define the dates for your graph and force it to show only the most-recent eight weeks.

Do you have an example file available?  

-Glenn

Here is just one example of how you might do this.

The attached file has a sheet of transactions ("Data"), a PivotTable that summarizes them by weeks ("Pivot"), and a table and chart that only shows the last eight weeks of data ("Chart - Last 8 Weeks").

There is a named range called "OldestWeek" that calculates the week ending date that is seven weeks earlier than the most-recent date shown in the PivotTable.  Cell A2 of the Chart worksheet references that date and the cells below increment until the most-recent date.  GETPIVOTDATA functions return the sales amount.  These are then used to plot the data for the final eight weeks.

Note that I've also included another column on the Chart sheet (column C) that returns the total sales directly from the Data without the need to reference the PivotTable.  Similarly, the range "OldestWeek" could point to the Data and derive that value also.

Regards,
-Glenn
EE-RecentWeekCharting.xlsx

Ok, I am looking at this sheet and I think this will work if I can get the dates across the top going horizontal. I have Techs names going down the left and the dates going across the top and of course the data in the pivot.

I also need to exclude weekends and holiday from the formula.

You'll have to post a more-specific example.  I had to create mine from scratch and it's just a hypothetical demonstration of how one might proceed.  

Weekends and holidays can be addressed using various Excel functions, for example, NETWORKDAYS.

-Glenn

All,

Here is a sample sheet. What I want to do is graph automatically the last 8 weeks on the pivot. Then each week the pivot grows I need to graph the previous 8 weeks again.
samplesheet61015.xlsx

OK I figured out a way to get the dates to change each week. I just dropped =today() in a cell and I am using my weekending formula to display the weekending date for the week (the formula looks at the cell which has =today()  ) I deducted -7 -14 -21 etc up to 8 weeks - now all I need to do is figure out a formula that will look up the names in Column A  A3 - A38  and the dates in columns B2, C2, D2, E2, F2, G2, H2, J2 and display that data.

Thank you! This is perfect!