Search results

I ended up finding the solution.... What is hard to tell from the chart on the right is there are some categories with very small numbers. Thus I used up all the darker colors with those smaller numbers. I discovered this when just choosing the top 10 categories and the colors matched...

There is too much data to post the xls file but basically the image below has two charts.... Based on same table data but different pivot tables off that data. Then I created two pivot charts. I wanted the chart on the right to have the same coloring(fill) as the chart on the left. Even...

I created a table (say table2) of data. I summarized the data using a pivot chart and formatted the stacked bar chart using one of the preselected styles. This is ok. Next I created another summary pivot table from the same underlying data and plotted a subset of the data using pivot chart...

Ahhh... Thanks. I was so close but this is working well Thanks!

How did you get the Have Fun in to C7? If I add the activity code it changes the size and format. Do I need to add the activity code to the pivot table or is there a way to look up the member info from another table to do the condition. Based on what you added, I need the activity code in...

Sajan, I've been working with this and haven't been able to get it to work. Here is the sample sheet. I am using a variation of one of Chandoo's templates and I am assuming an member is associated with only one activity. So the legend page has the activity and code (i put this in). Now if I...

Hi All, I have a pivot table where I like my current layout but now I've been asked to add some colors to each row. Basically, I have a row for each project and the columns list the months. The fields currently show hours. Jan Feb Mar .... Dec Project 1 Project 2...

Thanks!

Thanks for the quick response and solution. (As an FYI, there could be left over but I can just use the ceiling in the last column.) Using the your great response and example, my second question would apply to the ceiling. For the first column which has a ceiling of 20, for the three rows...

I am tying to spread a number in a cell across 16 cells. So if I have 100 in a cell how can I create a formula to spread that across multiple columns (10) BUT I have a max per cell (so if 100/10 would mean 10 per column but if there were 5 columns then the result would still be 10 per column...

Hi I have a list of data that I am looking to find the sum for the top 80% of the data and the count of number of unique rows in that data. (i.e. large, medium, small) I only want to do this for Sales person x. I know I can do some of this in a pivot table but I am looking to do it using...