Excel hotdoughnut

[salgerman]

Hi, first time VB poster, here...need a lot of help.

I co-worker came to me because I have previously functioned as a programmer (Tcl, Python, Fortran, C) but mostly (physics modeling) on the Linux side, rarely use Excel and know nothing about Visual Basic (neither does he)...but I would like to help him achieve what he wants to do.

After he explained to me what he wants, I went on to google and found this and corresponding cDataSet.xlsm...downloaded it and played around with it...not only does it not look like is working properly (or the integer math does not quite work out), but I don't know how to tweak it to make it do what I need.

I would like to make something like in the attached picture, where the outside ring is supposed to be a motor stator and the inner circle the temperature of the one side of the winding in such position:
I would like the inner circle to color-itself in a way proportional to the temperature; it is kind of doing it, but I don't know why 4, 7, 17, 20 are the color they are since these and all other blue ones are zero (something with the math in the macro).

Is anybody familiar with such work?
would somebody know how to tweak "doughnutExample", for example, to do what I need?

 

[salgerman]

Oh, in addition to the color, it would be nice to also display the temperature in each winding...you know, similar to how the number are shown in the outer circle.

Thanks in advance for any hints or complete solution to this problem.

gsal

 

[SkipVought]

Hi,

Proportional to temp--take a look at RGB values for color intensity. Use your macro recorder to help anchor a reference to a color.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}