That was quick reply, but if you notice the date i want is in financial year and that's fixed if "end date falls with that date chart would look fine but if date goes above my FY13. it should plot whole line. (look project 4)
I was thinking about putting an extra column and hiding it but still looks can't work..
Look at project 5 and project 7.
project 7 will be reject as it will not fall with in our calender but project 5 will over drawn as it exceeds our calender.
btw i have seen some where a combination of two or more calenders. i was planning to add here later to this chart. if this didn't work out.
You can adjust the min/max of the y-axis to limit the date range.
As your data doesn't have a start date, I'm not completely sure what your chart is trying to show.