Merge two graphs from same source

[ZeDoctor]

Hi guys,

I've got what seems like a really stupid problem. I've got a source of data and managed to create two separate graphs off pivot tables from the data, but what I really want is to have both of these on one graph and can't figure out how to do it.

I've attached a sample worksheet to help. So on each line of data I have an estimated date of departure and an actual date of departure - I need the graph to have one series as chargeable weight shipped on the actual dates and one series to show chargeable weight shipped on estimated dates. Hope that's clear. I can't for the life of me figure it out.

Any help is very very appreciated. Thanks guys