Forum Discussion
Line Chart with overlapping dates
So I have yet to find anything that can help but i'd love to be able to make a line chart that compares contract years of a specific contract. However the dates are unusual. The contracts run from ...
Hi bwilli33
I used this data set as in your example i found no overlap:
| 12/1/2009 | 444.5 | 2010 |
| 12/2/2009 | 438 | 2010 |
| 12/3/2009 | 433.75 | 2010 |
| 12/4/2009 | 424.5 | 2010 |
| 12/7/2009 | 419.75 | 2010 |
| 12/8/2009 | 420.75 | 2010 |
| 12/9/2009 | 420 | 2010 |
| 12/7/2009 | 419.75 | 2011 |
| 12/8/2009 | 420.75 | 2011 |
| 12/9/2009 | 420 | 2011 |
| 12/10/2009 | 418 | 2011 |
I made the 3 overlaps bold. also assuming they have the exact same value. i created this linechart:
- There is an issue when uploading pictures.. Here is a link:
http://prntscr.com/txrfm0
I put Date in Axis, ContractYear in legend and value in values.
Is this what you mean?