Hello... I'm not even sure this can be done in Excel, but here goes! I am trying to figure out a way to make a chart similar to the image attached to this post. It doesn't have to be a donut, but that would be preferable. I am trying to format the color each cell of the series based on a given value (Pass, Warning, Fail, or 0,1,2,3...). This is easy to do in a worksheet with conditional formatting, but trying to get each block or gradient of the data series to format has me stumped! I have some VBA code to set the color of a given series, but as soon as I add additional data, the new data reverts back to the colors in the chart style.
Thank you!
![upload_2016-8-3_12-27-32.png upload_2016-8-3_12-27-32.png](https://chandoo.org/forum/data/attachments/33/33337-b4b8947304f9c42181b95e5d45130ecb.jpg)
Thank you!
![upload_2016-8-3_12-27-32.png upload_2016-8-3_12-27-32.png](https://chandoo.org/forum/data/attachments/33/33337-b4b8947304f9c42181b95e5d45130ecb.jpg)