Charting combined amounts based on the same days

[mewingkitty]

Hi gang!
Long time no see.
Sorry I haven't been around, I picked up a couple other hobbies and haven't had any time to be on Excel as much as I'd like to be.

On that note, I can't figure out if there's a way to do this without just throwing more VB at the situation, and it seems to me there should be a setting of some sort to make this happen.

Please find attached workbook.
I've set up some decent VB buttons which call macros that I've written. These file and chronologically sort the few items on the main page. They also create new pages for new name entries.

The concept is that it adds dates in order and tallies the square footage total done on a given day by a given person, and lets us look that information up later on based on a 1 week, 1 month, 3 month, or 6 month schedule. Those can be picked from the drop down list next to "timeline".

If you take a look at the example I have placed in the posted workbook, I've inputted 2 orders for the same day. The chart however, can not read my mind, despite me starting at the screen and attempting to use my jedi mind powers on it, and does not add the totals for same-day orders.

So, long story short, is there a way to set that chart to total the footage for the dates or should I just pile on some more VB and set up a second set of columns with the totals added in it?

Oh and this is supposed to be Excel 2003 compatible, hopefully I haven't already messed that up by working on it with my Excel 2007 at home. Apparently I have a higher tech budget than my employer does :P

Any help would be appreciated greatly.

mew!

[Andy Pope]

You either need to use a pivot table to summarize the data or formula.

[mewingkitty]

Otay,
thanks!