Profile cover photo
Profile photo
Michael Barker
110 followers
110 followers
About
Michael's interests
View all
Michael's posts

Post has attachment
Hi All,

I have an issue that I'm hoping someone can resolve.  I have a data set from which I am creating multiple pivot tables and charts based on those tables.  In my previous version of Excel (2003) I could copy the chart, paste a new copy and change the data range to a different pivot table (this would keep the formatting the same for each chart without my having to reformat).  I've found that when I'm referencing a pivot table for the source pivot chart, I cannot edit the data range.  This option is greyed out in Excel 2007 (refer to the picture attachment).  I have a work around, but it requires that i copy the pivot table data and paste it as 'values' and reference those values.  This is very inefficient.  Can anyone tell me why I can't modify the data range once I have built a pivot chart from data in a pivot table?

Thanks for any assistance!
Photo

Post has attachment
Shutdown corner?? I think so!!

Post has attachment
This game rocks!

Post has attachment
Nope.. they'll be just fine!

Post has shared content
hehe!

Post has shared content
No, Apple Is NOT the Most Valuable Company Ever

Just about every major news outlet this week has been reporting that Apple is the most valuable company in history. But this is true only if you fail to adjust for inflation.

Microsoft holds the record for the highest valuation of any company in history. In 1999, Microsoft was worth $620.6 which, when adjusted for inflation, is worth $856 billion in today's money. 

So please stop being dumb, media.

http://www.cjr.org/the_audit/misleading_and_incomplete_cove.php

UPDATE: This post has been updated to correct an error in the post I linked to, which itself has been corrected.

Post has attachment
If they pick it up like Vinnie and Trey we will be in good shape!

Post has attachment

Post has attachment

Post has shared content
Seriously....
Wait while more posts are being loaded