Pivot Table Chart
 

We are attempting to create a chart from a pivot table. We only want to
chart the last 6 months. However, when you select August, September,
October, November, December, and January. it wants to pull data in from
January 2007 as well as 2008. Is there another way to tell it only Jan of
2008.

Pivot Table Chart
 

Hi
Can you have Year as a Page field?
If you haven't done so already with your Date field, then under Group and
OutlineGroupselect Year as well as Month
Then drag Year to Page field and use dropdown to select 2007.


--
Regards
Roger Govier

"Hojo" wrote in message
...
We are attempting to create a chart from a pivot table. We only want to
chart the last 6 months. However, when you select August, September,
October, November, December, and January. it wants to pull data in from
January 2007 as well as 2008. Is there another way to tell it only Jan of
2008.