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

pivot-like chart for text data
 

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