Profile

Cover photo
Michael Barker
Lives in Birmingham, AL
111 followers|166,171 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  - 
 
Seriously....
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 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
111 people
Maz Falaq's profile photo
Chris Bayle's profile photo
Excel For Noobs's profile photo
R. Slate's profile photo
Daniel McCullum's profile photo
Banks Douglass's profile photo
Geoff Bulpitt's profile photo
Jessica Lanford's profile photo
Trav el Gonzo'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.
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.... >.<
1
Add a comment...
People
Have him in circles
111 people
Maz Falaq's profile photo
Chris Bayle's profile photo
Excel For Noobs's profile photo
R. Slate's profile photo
Daniel McCullum's profile photo
Banks Douglass's profile photo
Geoff Bulpitt's profile photo
Jessica Lanford's profile photo
Trav el Gonzo's profile photo
Collections Michael is following
Links
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
Basic Information
Gender
Male
Great place. Nice staff. They were very accommodating. I recommend this Hampton inn.
Public - a month ago
reviewed a month ago
The bed was comfortable and the room was very spacious (corner suite). The breakfast was good and the staff was friendly.
Public - a month ago
reviewed a month ago
It's really nice place.the art and architecture are beautiful. It was a great place for a rehearsal dinner.
Public - 2 months ago
reviewed 2 months ago
It's nice but they nickel and dime you to death. Parking is min $22 per night and that entails a hike through the garage. $25 for breakfast and it wasn't special and the coffee was awful
Public - 3 months ago
reviewed 3 months ago
24 reviews
Map
Map
Map
I hesitate to say the worst experience I've had a dentist, but pretty close. First, they misled me to think my insurance would cover my cleaning. I got a bill for 106 in excess of what my insurance paid (for a cleaning!). So they grossly overcharge. Second, the hygienist massacred my mouth while taking 18 (yes) 18 x-rays of my mouth. They DO NOT HAVE the machine that takes them all at once. I complained half way through the x-rays but she continued to butcher my mouth with the films (I was bleeding). Then I finally get a cleaning (I'm there for 2 hours). When the dentist visits, I have 1 complaint. The crown on my implant is loose. The dentist points to 1 of the 18 x-rays and tells me "see here on the x-ray, it's not loose". Just so you know, I walked out of the dentist and pulled the crown right off my tooth. He never even felt it. I disputed my bill and it was summarily sent to collections. I have written a letter to Delta Dental in hopes that they will drop this dentist for misleading clients and very poor service. Please don't make the mistake that I made. Go somewhere else. Oh yeah, it really doesn't matter, but the toothbrush and floss that gave me must have come from the dollar tree.. it was off brand and awful.. you'd think I could get a name brand for a $250 cleaning.. AWFUL
• • •
Public - 2 months ago
reviewed 2 months ago
The staff is top notch. Rooms are nice. Restaurants are slow but good. Stay here
Public - 2 months ago
reviewed 2 months ago
The rooms were ok. However they weren't ready when we got there. The desk isn't staffed 24/7.
Public - 3 months ago
reviewed 3 months ago