Interface Pie Chart

[Nathan_Ramey]

Hello!

I am trying to create pie graph, that combines data from mutiple different fields and show them together

For example:

I want to combine that data and show that Group 1 had 61% of the score and so on. In one graph is there a way to do this?

[Ella]

Is it absolutely necessary for your data to be stored in wide format like that? I wanted to do the exact same chart as you but I had to transform all my data into vertical format.

I would be very interested to know if you can make this work the way you have your fields formatted.

[Nathan_Ramey]

What do you mean by Vertical format? The percentages are in three different records?

[Ella]

Hi @Nathan_Ramey ,

Have 1 column which indicates the group number and 1 column which indicates the percent.

I realize in some cases this is sub-optimal. This is just what I had to do to get my data displayed in a pie chart. If you find away to display your data, stored the way it is currently, in a pie chart, I would really like to know,.

[hunterch]

Most likely will need to be Vertical format unless you do a formula column at the end and do =SUM() those 3 percent columns