Thread: How to combine occurences by date?

I'm trying to make a graph of the occurrence of a certain term on a certain date. Right now, I have a database of articles listed, and every time the term is said in the article, i put a "1" in the adjacent column. When I try to graph this, Excel gives multiple bars for a single date if the term occurred more than once, for example, I have 5 entries for 11/26/2008, so there are five bars on my graph that all go up to 1. What I want is for Excel to combine all those entries, so that there is 1 bar that goes up to 5. I know how to do "count if" but is there a way to set this up so that excel will automatically add all entries on a specific date and then group them as one bar on a bar graph?

Thanks.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

If you need the dates between on the horizontal axis where no instances exist then perhaps something like the attached ?

If not (ie plot only days with values) then you could run your existing table into a Pivot Chart which would do the aggregation for you.

there's an Intro link in my sig.