Excel Date Range Trend

[LucyK]

Hi All,

I have just registered here, I am having trouble working out how to represent a trend in excel only using an Open and Closed date range.

I have approximately 350 rows of date ranges and I need to show a trend between when a finding opened versus when it closed (i.e resolved) I can't seem to get an excel graph to represent that data effectively.

Any help would be appreciated

Thanks,
Lucy