Same Category Names Combined before Graphing

Hi,

I think the easiest way is to use a pivot table and summarize your data by industry.
In your case your data will be summarized using the sum function as a default, but you can easily change that to an average.

In case you are not familiar with pivot table:

1. In the data menu click Pivot Table and then follow the wizard.
2. When you get the pivot table field list:
a. Drop the "industry" filed in the area where its says "Drop row fields here".
b. Drop the percentage filed in the area where its says "Drop data items here".
C. Double click on "sum of ..." and change that to "average".
3. You can then plot a chart using the pivot table instead of your detailed data.

Note: your data must have columns headings.

I hope this helps.

Regards.