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?


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

    (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?