Hi,

I'm working with the stock market, trying to create a column graph.

I am trying to get my graph to display industry vs. percent growth. However, the way my excel spreadsheet is setup I have the same industry written down more than once.

For example, my chart looks like this:

Stock - Industry - Percent Change
CYTX - Biotechnology - +2.02%
ESLR - Electrical Components - -16.64%
MNTA - Biotechnology - -6.64%

and so on...

When I go to plot industry vs. percent change in a column bar graph, the same industry will show up twice. Instead I want it to group industries together and also average the two percent changes together.

Is there an easy way to do this and do I a present my problem clearly?

Thanks

Mark