F
forbes
Hi,
I know that you cannot use a pivot chart for text values; but I'd like
something similar. I have data in a worksheet that looks something like
this:
Food Carbohydrate (in Grams) Fat (in grams)
Bread, 1 slice 15 1
Croissant, 1 ounce 12 6
Corn Flakes, 1 cup 24 0
I would like a pivot-like chart with Carbohydrates in the x-axis and
Fats in the Y-axis and the food items as the data.
Is there any solutions?
Thanks
Kim
I know that you cannot use a pivot chart for text values; but I'd like
something similar. I have data in a worksheet that looks something like
this:
Food Carbohydrate (in Grams) Fat (in grams)
Bread, 1 slice 15 1
Croissant, 1 ounce 12 6
Corn Flakes, 1 cup 24 0
I would like a pivot-like chart with Carbohydrates in the x-axis and
Fats in the Y-axis and the food items as the data.
Is there any solutions?
Thanks
Kim