Profile

Cover photo
Michael Barker
Lives in Birmingham, AL
103 followers|118,561 views
AboutPostsPhotosYouTubeReviews

Stream

Michael Barker

Ask a Q ("Help me!")  - 
 
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!
1
Paul Seda's profile photo
 
Sounds like a pivot cache issue.  That means the chart is dependent on the existence of a pivot cache in order for you to modify it.  If you remove the range (the input for the pivot cache), you can't have an object of type PivotChart.  That's the only thing that comes to mind; I could be wrong.

Have you tried saving the chart as a Template?  Go to the Design Tab under PivotChart Tools and look on the left-hand side of the ribbon.  Save it with a name.  Create a new chart from a different pivot table.  Then click the "Change Chart Type" button on the Design tab and select your newly saved template. You can change the chart type again to get the same formatting while changing actual chart types (from bar to pie or something else).
Add a comment...

Michael Barker

Shared publicly  - 
 
This game rocks!
1
Add a comment...

Michael Barker

Shared publicly  - 
1
Add a comment...

Michael Barker

Shared publicly  - 
1
Add a comment...

Michael Barker

Shared publicly  - 
 
Please don't tell anyone on facebook about this... those fetus trackers are weird enough already +Teri Stewart +Banks Douglass 
1
1
Teri Kirkendoll's profile photoMichael Barker's profile photo
 
Oh my god!  NO! That is the most disgusting, unnatural thing I have ever seen.  I think I just threw up in my mouth. GOOD GOD WHY!!!   
Add a comment...
Have him in circles
103 people
Jack Ryan's profile photo
alexia joubert's profile photo
Molly McQuitty's profile photo
Jared Schepman's profile photo
Heather Kinsaul's profile photo
JENNIFER SMOTHERS's profile photo
JOEL ALDRIDGE's profile photo
Stacy Cochrane's profile photo
William Rosenfeld's profile photo

Michael Barker

Shared publicly  - 
 
Shutdown corner?? I think so!!
1
John Barker's profile photo
 
Hell yeah
Add a comment...

Michael Barker

Shared publicly  - 
 
Nope.. they'll be just fine!
1
Banks Douglass's profile photoMichael Barker's profile photo
2 comments
 
10 days and we'll let them know... sorry Denard, it's going to be a tough 1st day of September!
Add a comment...

Michael Barker

Shared publicly  - 
 
 
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.
354 comments on original post
1
Add a comment...

Michael Barker

Shared publicly  - 
 
If they pick it up like Vinnie and Trey we will be in good shape!
1
Add a comment...

Michael Barker

Shared publicly  - 
 
No doubt!
 
++ re-share if you get same problem.... >.<
20 comments on original post
1
Add a comment...
People
Have him in circles
103 people
Jack Ryan's profile photo
alexia joubert's profile photo
Molly McQuitty's profile photo
Jared Schepman's profile photo
Heather Kinsaul's profile photo
JENNIFER SMOTHERS's profile photo
JOEL ALDRIDGE's profile photo
Stacy Cochrane's profile photo
William Rosenfeld's profile photo
Basic Information
Gender
Male
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Birmingham, AL
Previously
Birmingham, AL - Tuscaloosa, AL - Nashville, TN - Vina, AL
Links
Contributor to
Excellent.. Try the Jerky.. and the take home and cook meals are fantastic!
Public - 5 months ago
reviewed 5 months ago
Good fast Chinese.. always ready in 'ten minute'!
Food: ExcellentDecor: GoodService: Excellent
Public - 2 years ago
reviewed 2 years ago
Excellent scene. Good People. Good Beer! I highly recommend visiting this joint!
Public - 2 years ago
reviewed 2 years ago
4 reviews
Map
Map
Map
Great Sandwich. Mega meat! Service with a smile!
Quality: ExcellentAppeal: ExcellentService: Excellent
Public - 2 years ago
reviewed 2 years ago