Pivot Table Chart

H

Hojo

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.
 
R

Roger Govier

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display Pivot table summary in order of increasing time frame 4
Pivot Chart 2
Mapping strings to integers 5
Row to column conversion 4
Pivot Table Grouping by Quarters 3
to find the repetitve text from a column. 4
Monthly Percent Increase 1
Sort pivot table field (droplist) by month or original data 1

Top