Jun 25 2022 06:28 AM
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 or direction where I can find help would be greatly appreciated.
Jun 25 2022 06:55 AM
You could help us help you by saying a bit more about how your rows of data are arrayed. What are the columns. Is there a start and end date in each row? Etc.
Ideally, post a copy of the workbook itself on OneDrive or GoogleDrive and grant access. Just make sure you're not revealing any confidential or proprietary data.
Jun 25 2022 07:23 AM
Jun 25 2022 08:00 AM
Jun 25 2022 08:18 AM
You don't actually say what "trend" you're seeking. I'm making an assumption here that it's a trend in the length of time between Open and Close--duration of "Open"--so I've added a column that just calculates that length of time. The whole table can then be sorted based on either the start dates or the end dates. The sort by start date creates a line graph as shown here, and a clear trend is apparent. The question is simply: "Is this what you are looking for?"
Jun 25 2022 08:40 AM