Chart colour macro

[Jstns]

Hi Guys!

I have a macro that changes the RGB color code of any chart in a workbook through a loop. The code however only works on some charts (column chart, area chart, etc.) but not on a histogram, pie chart or such types of charts.

Could you help out?

This is my code:

Please Login or Register  to view this content.

Thank you all!

[NickyC]

Hi
I am guessing your problem is because the segments in pie charts are not additional series but points in a single series.

This variation to your macro should apply your colour scheme to different points in series one rather than successive series if your chart has only one series.

Please Login or Register  to view this content.

[Jstns]

Wow I thought I replied @Nickyc ! Thank you so much, it worked(Y)