pivot-like chart for text data

  • Thread starter Thread starter forbes
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Reg: Preparing Charts using Pivot Data 6
Refreshing pivot makes second data series line disappear from chart !!! 4
Office Excel 2007 Pivot Data Charting 2
Using text as data? 0
charting variable line data 1
Formatting pivot chart axis labels for dates 10
Replacing numeric X-axis labels with corresponding text string 2

Back
Top