yes definitely thank you thank you!
var text SZ = "200"; //Adjust this number to make the pie bigger or smaller
var text ACOL = "LightSkyBlue "; //Heating All Fuels
var text BCOL = "Gold "; //Cooling All Fuels
var text CCOL = "Hotpink "; //Ventilation All Fuels
var text DCOL = "MediumOrchid "; //Domestic Hot Water
var text ECOL = "CornflowerBlue "; //Lighting
var text FCOL = "Lime "; //Cooking
var text GCOL = "yellow "; //Refrigeration
var text HCOL = "DarkViolet "; //Office Equipment
var text ICOL = "red "; //Computer
var text JCOL = "orange "; //Misc
var text ALABEL = "Heating " & ToText(Round([Heating Electric Use Percentage]*100,1)) & "%";
var text BLABEL = "Cooling " & ToText(Round([Cooling Electric Use Percentage]*100,1)) & "%";
var text CLABEL = "Ventilation " & ToText(Round([Ventilation Electric Use Percentage]*100,1)) & "%";
var text DLABEL = "Domestic Hot Water " & ToText(Round([Domestic Hot Water Electric Use Percentage]*100,1)) & "%";
var text ELABEL = "Lighting " & ToText(Round([Lighting Electric Use Percentage]*100,1)) & "%";
var text FLABEL = "Cooking " & ToText(Round([Cooking Electric Use Percentage]*100,1)) & "%";
var text GLABEL = "Refrigeration " & ToText(Round([Refrigeration Electric Use Percentage]*100,1)) & "%";
var text HLABEL = "Office Equipment " & ToText(Round([Office Equipment Electric Use Percentage]*100,1)) & "%";
var text ILABEL = "Computer " & ToText(Round([Computer Electric Use Percentage]*100,1)) & "%";
var text JLABEL = "Miscellaneous " & ToText(Round([Miscellaneous Electric Use Percentage]*100,1)) & "%";
var number denom = If([Total Electric Use Chart] = 0, 0, [Total Electric Use Chart]);
var number A = If([Total Electric Use Chart] = 0, 0, [Heating kWh] / [Total Electric Use Chart]);
var number B = If([Total Electric Use Chart] = 0, 0, [Cooling kWh] / [Total Electric Use Chart]);
var number C = If([Total Electric Use Chart] = 0, 0, [Ventilation kWh] / [Total Electric Use Chart]);
var number D = If([Total Electric Use Chart] = 0, 0, [Domestic Hot Water kWh] / [Total Electric Use Chart]);
var number E = If([Total Electric Use Chart] = 0, 0, [Lighting kWh] / [Total Electric Use Chart]);
var number F = If([Total Electric Use Chart] = 0, 0, [Cooking kWh] / [Total Electric Use Chart]);
var number G = If([Total Electric Use Chart] = 0, 0, [Refrigeration kWh] / [Total Electric Use Chart]);
var number H = If([Total Electric Use Chart] = 0, 0, [Office Equipment kWh] / [Total Electric Use Chart]);
var number I = If([Total Electric Use Chart]= 0, 0, [Computer kWh] / [Total Electric Use Chart]);
var number J = If([Total Electric Use Chart] = 0, 0, [Miscellaneous kWh] / [Total Electric Use Chart]);
var text data =
ToText($A) & "," &
ToText($B) & "," &
ToText($C) & "," &
ToText($D) & "," &
ToText($E) & "," &
ToText($F) & "," &
ToText($G) & "," &
ToText($H) & "," &
ToText($I) & "," &
ToText($J);
var text colors =
"\"" & $ACOL & "\"," &
"\"" & $BCOL & "\"," &
"\"" & $CCOL & "\"," &
"\"" & $DCOL & "\"," &
"\"" & $ECOL & "\"," &
"\"" & $FCOL & "\"," &
"\"" & $GCOL & "\"," &
"\"" & $HCOL & "\"," &
"\"" & $ICOL & "\"," &
"\"" & $JCOL & "\"";
var text chartConfig =
URLEncode(
"{\"type\":\"pie\"," &
"\"options\":{\"legend\":{\"display\":false}," &
"\"plugins\":{\"legend\":{\"display\":false},\"datalabels\":{\"display\":false}},\"responsive\":false}," &
"\"data\":{" &
"\"labels\":[]," &
"\"datasets\":[{" &
"\"data\":[" & $data & "]," &
"\"backgroundColor\":[" & $colors & "]" &
"}]" &
"}" &
"}"
);
var text chartURL =
"https://quickchart.io/chart?width=" & $SZ & "&height=" & $SZ & "&c=" & $chartConfig;
var text pieChartHTML =
"<div style='display:inline-block; vertical-align:top; margin-right: 30px;'>" &
"<img src='" & $chartURL & "' width='" & $SZ & "' height='" & $SZ & "' style='border-radius:50%;'/>" &
"</div>";
var text keyHTML =
"<div style='display:inline-block; vertical-align:top;'>" &
"<div><span style='display:inline-block;width:10px;height:10px;background-color:" & $ACOL & ";margin-right:5px;'></span>" & $ALABEL & "</div>" &
"<div><span style='display:inline-block;width:10px;height:10px;background-color:" & $BCOL & ";margin-right:5px;'></span>" & $BLABEL & "</div>" &
"<div><span style='display:inline-block;width:10px;height:10px;background-color:" & $CCOL & ";margin-right:5px;'></span>" & $CLABEL & "</div>" &
"<div><span style='display:inline-block;width:10px;height:10px;background-color:" & $DCOL & ";margin-right:5px;'></span>" & $DLABEL & "</div>" &
"<div><span style='display:inline-block;width:10px;height:10px;background-color:" & $ECOL & ";margin-right:5px;'></span>" & $ELABEL & "</div>" &
"<div><span style='display:inline-block;width:10px;height:10px;background-color:" & $FCOL & ";margin-right:5px;'></span>" & $FLABEL & "</div>" &
"<div><span style='display:inline-block;width:10px;height:10px;background-color:" & $GCOL & ";margin-right:5px;'></span>" & $GLABEL & "</div>" &
"<div><span style='display:inline-block;width:10px;height:10px;background-color:" & $HCOL & ";margin-right:5px;'></span>" & $HLABEL & "</div>" &
"<div><span style='display:inline-block;width:10px;height:10px;background-color:" & $ICOL & ";margin-right:5px;'></span>" & $ILABEL & "</div>" &
"<div><span style='display:inline-block;width:10px;height:10px;background-color:" & $JCOL & ";margin-right:5px;'></span>" & $JLABEL & "</div>" &
"</div>";
$pieChartHTML & $keyHTML