Search results

HOOOOOOOOOOORAAAAAAAAYYYYYYYYYY I think I finally figured it out. The problem was that I had Agency as the column or row labels in my pivot tables, so the charts had each agency as its own series. You can only format the data labels for one series at a time. So this is why I had to reformat...

*sigh* I don't know what I'm doing wrong. I tried what you said and it just won't work for me. I click on a chart to highlight it, go to the design tab, click Change Chart Type, select my custom template. That individual agency's chart looks fine, but then again, if I click on a different...

Thank you so much for continuing to help me with this problem! However, I think we just may not be communicating well. I don't want the charts to be independent of each other. I want them all to have the same style, and that style to stay the same every time I click on a different Agency...

Well it is closer - on yours the colors stay the same but I notice that the data labels are % for Agency 1 but not the other agencies. Do you know what you did differently to keep the colors the same so I could reproduce it?

Thanks. I did use PivotTable Connections to connect all of my charts to the Agency slicer, so they all change together to show the data for each individual agency when I click on the slicer. So that part is working fine. My only problem is that when you click on Agency 1, the chart looks how I...

OK here it is in google docs. If you download it then you can open it in Excel 2010. Hopefully that's ok. https://docs.google.com/file/d/0ByNBbSD3NjstWkFBRHItbTdBV3c/edit?usp=sharing

No problem. Once I hit the upload button I'll be running around with my 2 year old anyway, so I won't look at it again until morning either. have a good night!

Ok mine doesn't look like that at all. I made a simplified example to show you but unfortunately drop box is a blocked site in my office. (practically everything is blocked here!) I will upload it when I get home tonight.

No, I don't think I am allowed to do that since it is confidential data for state funded school programs. Each program is located in a different school. The slicer is so that program administrators can send easily send a snapshot report to each individual program. Maybe it will help to say the...

Hi bobhc, thanks for the reply. However, maybe I wasn't clear in my original post. There are actually only 4 charts, but 60 agencies within the one slicer. The problem is happening within each individual chart. In other words, I set each pie chart with the colors I want and make the data...

Hi All I created a dynamic report with several charts all connected to a single slicer in Excel 2010. The slicer, "Agency", contains about 60 agencies, so when users click on it the charts automatically update with the data just for that particular agency. For some reason when I create a...

Derp how embarrasing, I figured it out. In the case when it showed blank, it was because my data source was a range that included blank rows. In the case where it showed 0, for some reason in the Table it was automatically adding another row for 0. As soon as I changed it back to a range...

Here's a little more info. I believe it is there for items with no data, but there are no items without data in that particular field (Agency Name). It also isn't that the pivot table refers to an extra row with no data - it refers to Table1. So I don't see any blank or missing data anywhere...

Hi All. This is my 1st post but I'm an avid chandoo reader. So many great tips here! I hope to post more now that I've registered. My current question has to do with slicers and pivot tables. I'm wondering why does a row for "blank" always show up in pivot tables? Before it was never a problem...