How Do I Make a Same Color Pie Chart that gets Lighter as the amounts descend

I'm posting to get this on my subscribed list so I can follow-up tomorrow with an explanation. I actually want to modify it so you can use Green or Blue as well and possibly even a red to green scheme. Too close to quitting time now .

Here is the spreadsheet and how it works.

Select the color using the drop-down list in Cell V1.

Select the maximum value. This needs a bit of an explanation. If you select 1, since we are working with percents, 100% will be the most intense color and 0% will be no color at all. Other colors will fade from darkest to lightest. However, when you have a lot of percentages, the biggest of them is rather small and the colors fade from light to lightest since, as in the example, you are a quarter of the way down the scale already.

If you pick a maximum close to the maximum in the data then the program "rescales" the values so that internally, the biggest percent is treated as 100% and you get a better range of colors.

Play with this to suit your tastes. It turns out that the blue in very dark and makes it difficult to read the text. I tried 0.5 as a value and it looks nice.

If you select a number lower than the maximum, you will get a narrower range of colors on the darker side.

A word of warning: the code expects the chart to be on the same sheet with the button and for it to be the first chart on the sheet (or what Excel thinks the first chart is). So if you have multiple pages, you can add a button assigned to the macro on each page.