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