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

 

[JCScoobyRS]

Can anyone help me with the chart/graphing abilities of Excel? Thanks, Jeremy

 

[Mark W.]

Summarize your data with a PivotTable and create your chart from it.

Book1
	A	B	C	D	E	F	G	H
1	Company
2	AcmeProducts
3	ABCPlumbing		CountofCompany
4	GizmosUnlimited		Company	Total
5	ABCPlumbing		ABCPlumbing	50.00%
6	ABCPlumbing		AcmeProducts	20.00%
7	ABCPlumbing		GizmosUnlimited	30.00%
8	AcmeProducts
9	ABCPlumbing
10	GizmosUnlimited
11	GizmosUnlimited
12
Sheet5

This message was edited by Mark W. on 2002-11-01 14:34

 

[JCScoobyRS]

That would work but I'd really like to be able to put that into a Pie Chart. Any idea on how to do that? Thanks, Jeremy

 

[Mark W.]

...and, you don't think that you can create a pie chart from a PivotTable?
This message was edited by Mark W. on 2002-11-01 14:34

 

[JCScoobyRS]

I don't know. I am new to graphing in Excel and I don't even know how to create a Pivot Table. Can you help me? Thanks, Jeremy

 

[Mark W.]

Fortunately, Excel has wizards that guide you step-by-step for both. First, see the Excel Help topic for "Guidelines for creating a list on a worksheet". PivotTables need a column label (e.g., Company) to occupy the 1st row of your data list. Next, click on any single cell in your data list and choose the Data | PivotTable... menu command. It should guide you through the creation process. Your Company field should occupy both the COLUMN and DATA areas. When done select your PivotTable and click on the Chart Wizard toolbar button (see the Excel Help topic for "Create a chart") and follow its instructions.

 

[JCScoobyRS]

I have created a Pivot Table but I get nothing from a chart, just like before. I created a list, made a pivot table from the list and it added a new sheet with the companies in the list, so the pivot table worked, but I still don't get any type of percentages like you did. Can you help? Thanks, Jeremy

 

[Mark W.]

What version of Excel are you using?

 

[JCScoobyRS]

2002 (Office XP Professional). Like I said, I don't know much about charting and the wizard did help me create the pivot table, thanks for the help, and the chart helps me create a chart but there's nothing in it. Please excuse my stupidity. Thanks, Jeremy