Hello! I’d like to show pie diagrams with the totals of each column but I can’t find a way. The link below shows up my table. I’d like to chart the totals of columns “TIPO” and “UF”. For example, the column TIPO has values “AR”, “PS” and “IM”. The pie chart must show the percentage of each value in this range.
I’ve just find a way. First I’ve added some frontend hidden rows and I used it labeling the values and its respective sums (by using =COUNTIF(C1:C195;”[PATTERN TO MATCH]”). Second, I used that values to draw the Diagrams and voil?.
.
.