Try this approach:

http://peltiertech.com/Excel/ChartsH...idateData.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"susann" wrote in message
...
I am trying to graph information from a spreadsheet that has been exported
from another program (a time-recording program).

It basically puts the information like this:

matter 1 - 5
matter 2 - 10
matter 3 - 2
matter 2 - 5
matter 2 - 10
etc
etc

I want to create a graph that charts the TOTAL of all matter one, etc.

I can't figure out how :(

Am using Excel 2007.

Thank you
Susan