View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
forbes forbes is offline
external usenet poster
 
Posts: 5
Default pivot-like chart for text data

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