Pie Chart Colors

  • Hello,


    I have been agonizing over this; I created a pie chart displaying different category elements in specific colors. My problem is that when I create new pie charts with the same category elements but different data elements, my selected colors for the category elements default back and I have to reassign my category colors. Is there a macro I can use to automatically assign/reassign specific colors to a pie chart's categories?


    :thanx:

  • Re: Pie Chart Colors


    Howdy. I use something like this:


    The two input boxes tell the code where the range references begins (col and row numbers).


    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt


    Old, slow, and confused - but at least I'm inconsistent!


    Rich
    (retired Excel 2003 user, 3.28.2008)

  • Re: Pie Chart Colors


    Many thanks this works very well, and is there a suggested method to fix the references within the code? for example fixing the row and instead of specifying a column number typing in the name within the column range to look for?