Graphing by Column Contents

JCScoobyRS

Board Regular
Joined
Sep 17, 2002
Messages
102
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
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

JCScoobyRS

Board Regular
Joined
Sep 17, 2002
Messages
102
Can anyone help me with the chart/graphing abilities of Excel? Thanks, Jeremy
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
Summarize your data with a PivotTable and create your chart from it.
Book1
ABCDEFGH
1Company
2AcmeProducts
3ABCPlumbingCountofCompany
4GizmosUnlimitedCompanyTotal
5ABCPlumbingABCPlumbing50.00%
6ABCPlumbingAcmeProducts20.00%
7ABCPlumbingGizmosUnlimited30.00%
8AcmeProducts
9ABCPlumbing
10GizmosUnlimited
11GizmosUnlimited
12
Sheet5

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

JCScoobyRS

Board Regular
Joined
Sep 17, 2002
Messages
102
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.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654

ADVERTISEMENT

...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

Board Regular
Joined
Sep 17, 2002
Messages
102
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.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654

ADVERTISEMENT

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

Board Regular
Joined
Sep 17, 2002
Messages
102
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
 

JCScoobyRS

Board Regular
Joined
Sep 17, 2002
Messages
102
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
 

Forum statistics

Threads
1,144,360
Messages
5,723,903
Members
422,526
Latest member
edminty84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top