Graphing by Column Contents

[JCScoobyRS]

I need to be able to take a columns, Company List, and create a graph for each occurance that the company shows up in the row, in percentage. Thanks, Jeremy

 

[Mark W.]

Have you selected a cell within the PivotTable when you choose the chart wizard?

 

[JCScoobyRS]

Yes I did. I created the Pivot Table and selected an item in the Pivot Table. Once I select it and click Chart Wizard, a chart automatically shows up with the correct companies at the bottom of the chart but nothing else. I don't even get to specify the parameters like I did before the Pivot Table was created. Any ideas? Thanks, Jeremy

 

[Mark W.]

What does your PivotTable look like?

 

[JCScoobyRS]

It's got one column with a row for each company, only listed once, just like yours. Thanks, Jeremy

 

[Mark W.]

...but, what field did you put in the DATA area?

 

[JCScoobyRS]

Nothing. That was the problem. Thanks, Jeremy