Make an XY chart with the Carbo and Fat data, then use one of these free
Excel add-ins to add the labels from the Food column to the data series:
Rob Bovey's Chart Labeler,
http://appspro.com
John Walkenbach's Chart Tools,
http://j-walk.com
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"forbes" wrote in message
ups.com...
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