all. I do not see an answer to my problem in this site, so hopefully I can find help from you all. I have a table of data, reflecting pseudo-Project Management data. The table is 7,000+ rows long but only 4 columns wide. Here is a very simplified example:
**PROJECT_NAME MILESTONE_TYPE MILESTONE_DATE REPORT_DATE** Project A Project Start 10/16/2017 6/1/2017 Project A Beta Finished 2/1/2017 6/1/2017 Project A Project Complete 11/1/2017 6/1/2017 Project A Project Start 10/16/2018 1/1/2018 Project A Beta Finished 3/1/2017 1/1/2018 Project A Project Complete 2/1/2018 1/1/2018 Project B Project Start 5/1/2018 6/1/2017 Project B Beta Finished 8/1/2018 6/1/2017 Project B Project Complete 2/1/2019 6/1/2017 Project B Project Start 5/1/2018 1/1/2018 Project B Beta Finished 8/1/2018 1/1/2018 Project B Project Complete 3/1/2019 1/1/2018
I want to display data for one project at a time (I expect to use a filter), although there are actually over 70 Projects. The 36 Report Dates are snapshots (progress reports, really) of anticipated Milestone Dates.
I want to show whether any Milestone Dates have slipped for a particular project, using a line graph that will indicate any changes to Milestone Dates over time. Each Milestone Type should be its own curve/line, and I want the line to track all report dates for that particular milestone along the x-axis. So, the Y-axis will reflect target dates for each milestone, while the X-axis will reflect dates each data point was gathered, as a "trend line."
I am very familiar with Office/VBA/etc. but very new to Pivot Tables and Pivot Charts. I found another similar question in this forum, but the solution is given for Excel 2010; I am working with Office 365, which means the settings referred to don't match (as far as I can see.)
I feel I'm this close, but I can't get it. Please help!