• 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.

Keeping color same for data series across multiple pie charts

C

CW

New Member
I have a workbook with several pie charts in it. Each chart has the same data labels as the other charts but different data in it. The order of the data labels changes from chart to chart. I need to keep the color the same for each data label in all the pie charts. Does anyone know how I can do this?
 
Rather than using different colors which forces readers to keep track of colors and names, why not just use some bar charts? Gets rid of the color issue, which helps reduce confusion and helps people who are color blind.
 
Thanks, Luke. Its tempting to change to one color but I don't think that's an option, whether I change to bar charts or keep as a pies.
 
Could you elaborate on what type of info you are trying to explain? Pie charts are not the best choice to use most of the time, so I'm surprised that you have so many. I'm thinking that either a bar, dot plot, or panel chart may do a better job depending on what "message" your charts are trying to convey.
 
Various information on the same set of organizations. I understand pie charts are best for a few data elements, not many. Even if I switch to bar charts I'll still be looking to do the same - have each organization represented by just one color in all the charts.
 
CW


Firstly, Welcome to the Chandoo.org Forums


If you setup your first chart as required

Then copy and paste the whole chart

Then adjust the data range for the second chart,

Provided the series are in the same order they should maintain the same sequance and hence colors


This will apply to both Pie and Other Charts


Otherwise you can save a Custom Chart type and load that for each subsequent chart
 
Hui - thanks for the welcome and for your advice. The data won't always be able to be in the same sequence. I'll check into saving a Custom Chart type. Thanks for your help.
 
Hi, CW!


As far as I know you'll have to get involved with a little of VBA code. Something like a one column table with the different data labels in all charts and setting each entry with the desired highlight or back color. Then from the code you can assign the "fixed" color for each data label.


Regards!
 
You must log in or register to reply here.
Back
Top