Greetings -

Sorry if the subject is not very explanitory, wasn't sure how to word it.
Basically my issue is I am trying to create some different charts from a
spreadsheet where there might be multiple rows for the same values that will
go on the X axis. For example this spreadsheet might have the following
Data:

ABC Company $500
BCD Company $332
XYZ Company $500
XYZ Company $200

When that chart is created (company on x axis, amount on Y axis) it creates
4 different columns (one each for ABC Company and BCD Company and two for
XYZ Company). What I would like it to do is to create only 3 different
columns (one each for the 3 companies). So the value for XYZ Company would
be $700 instead of two different columns with one for $500 and one for $200.
Is there a way to get Excel to add those together automatically?

This spreadsheet is created by importing 2 seperate files (from different
programs) into a spreadsheet, and each text file might have values for the
same companies in them, which is why there could be duplicates. There are
hundreds of companies in each file and each file might have some companies
that are not in the other file so not all will be duplicates.

If charting cannot do this automatically, does anyone know if there is a way
to add amounts together when importing a file. I am meaning something like
this: the first file is imported and the data added, then when the second
file is imported it would check to see if that company already exists, and
if so it just adds the amounts to the current row instead of creating a new
row.

Thanks for any help,
Jeff