1 of 1 people found this helpful
Welcome to the Forum,
The workbook attached in the forum thread has a few different methods.
-To overlap the two graphs you can use a dual axis method
-Pivot the dates into one column and then make some running sums
-make a helper sheet with a list of all possible days and then join
to your data when the lookupdate is between created and closed
These are generally discussed in the following links:
More detailed discussion in a similar vein
Thank you very much for the help! I was able to use the dual axis option to get the graphs to display as desired. I have one more question now... how do I change the color of the lines? It appears that the line color is based on the measure by default and therefore it will not let me make each line a distinct color.