I am attempting to create a line chart that shows FY15's Cumulative Actual Spending compared to FY16's Cumulative Actual and Planned Spending. Unfortunately the data source available to me only lets me pull in one range of dates so I have to pull in all of FY15 and FY16 as one dataset. I'm having a lot of trouble figuring out a way to show the data from both years separately on the same chart.
Here's what I have so far:
In the end I need to have three lines. One for FY15 Actual, FY16 Planned, and FY16 Actual (We are currently in Period 4 of FY16). The graph I have set up currently is combining the two years so the values are roughly double what they should be, and I want to be able to view them separately in the same chart.
Any help with this would be greatly appreciated. I've searched all over the forums and I've asked several people around the office for their thoughts and I haven't made any progress.