I would like my pivot table to display only the last 12 months of data.
Is there a setting i could change somewhere to make it only give me the
last 12 months? It is a lot of data points sum'd by month and year and
is giving me all 12 of 2005 and then 6 of 2006. I would like the six
of 2006 but only 7 and up of 2005.


--
Acro
------------------------------------------------------------------------
Acro's Profile: http://www.excelforum.com/member.php...o&userid=35456
View this thread: http://www.excelforum.com/showthread...hreadid=552411

Acro,

Check out Jon Peltier's site. I used this and it worked great.


http://peltiertech.com/Excel/Charts/...tml#DynoLast12


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=552411

Thanks steve i will try that! i hope that works when referencing pivot
tables for the data as well as just normal cells of data.


--
Acro
------------------------------------------------------------------------
Acro's Profile: http://www.excelforum.com/member.php...o&userid=35456
View this thread: http://www.excelforum.com/showthread...hreadid=552411

I do not believe this works when referencing a pivot table for data. I
could not get it to work. it says i have a reference to external data
or something like that even when i am not referencing any external
data! that must be because i'm referencing the pivot table. Any other
suggestions or am i out of luck?


--
Acro
------------------------------------------------------------------------
Acro's Profile: http://www.excelforum.com/member.php...o&userid=35456
View this thread: http://www.excelforum.com/showthread...hreadid=552411

Acro,

Off on vacation for a few days so I apologize for the late response.

Does your Pivot Table and data reside in the same workbook as your
chart? I just tried this using a pivot table whose source data & the
chart was in the same workbook and had no issues. If you have the data
in different books, they both need to be open to view the data
correctly.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=552411

Oh wow alright thanks I will attempt this again I must have just done
something wrong. The pivot tables i am trying to create the charts of
are getting data from a diff worksheet on the same workbook so it
should be good to go.


--
Acro
------------------------------------------------------------------------
Acro's Profile: http://www.excelforum.com/member.php...o&userid=35456
View this thread: http://www.excelforum.com/showthread...hreadid=552411