I am trying to make a donut chart that displays multiple components from one user’s single entry from a form. The purpose is for calculating someone’s average calorie consumption for a year and from what types of meals. For example, the user would fill out a form upon logging in that asks, “how many calories of alcohol do you drink per week?”, “how much meat do you eat?”, “dairy products?” etc., and they would enter calorie counts for each of those which would then populate in different columns of “alcohol,” “meat,” “dairy,” etc.
From there, I want to have a donut chart that shows each of these components and then a total calorie count. I was able to make this happen in a really convoluted way by making pivot tables in my sheet, but this takes up a ton of rows and is hard to display per user. Is there any way to make the donut chart display multiple columns like the bar charts do?