Bar of Pie Chart - Colors

Hi,
I’m extremely new to VBA and macros, literally started teaching myself yesterday to make better/more efficient graphs to represent data for work, so please forgive me for my inexperience.

But I'm compiling data into Bar of Pie charts and am wondering if it's at all possible to program the "Other" slice to be a certain color. The macros I made uses colors that are predetermined from the cells on excel, but...

• The charts don't have the same splitting point (where the "Other slice occurs") for the second plot because the data sets don't have the same number of datums
• The range for the chart is based off of what I select.

If someone could help, or even have suggestions for a more efficient way to format this, it would be greatly appreciated. Below is what I have so far in VBA. Thank you!

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

The "Others" slice is the last Point in the series. so you can use

Please Login or Register  to view this content.