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

Doughnut Chart linked with the slicer in the pivot table 0
Mapping strings to integers 6
Month days over a time period 5
Pivot Table Reports Year to date Values 4
Dealing with a Pivot Table (when I don't want to) 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
to find the repetitve text from a column. 4
Monthly Percent Increase 1

Top