• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

pivot chart formatting styles too light

J

jturn00

New Member
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 (stacked bar chart). The chart scaling is fine but I cannot choose the same standard style.

When I choose the same chart style the color is off and too light. There is no way to get it back to the other chart even though I chose the same standard chart styles.

There are lot of data items so choosing each item and formatting the fill isn't an option.

Why is it doing this? And how can I fix it?
 
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 thought I click the same chart styles in both charts, the shading is different? I cannot get them to be the same without going to each range and manually changing it. There are over 40+ items so that isn't an option.... Not sure why. Both charts are in the same workbook.


Capture.JPG
 
Hi ,

I tried reproducing your problem using a file that I had ; I am not able to.

If you can upload your file , it is possible I can see what the matter is ; otherwise I am sorry I cannot help.

Narayan
 
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. Thanks for looking into this!
 
You must log in or register to reply here.
Back
Top