• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Chart help ..

aamirsq

aamirsq

Member
Hi,

I m really tired today, i wanted to make a chart like shown.
how can i make .

thanks
 

Attachments

  • Sample-chart.xlsx
    8.9 KB · Views: 8
See attached with complete chart & instructions. :)
Hope you find some more energy soon. :awesome:
 

Attachments

  • Sample-chart LM.xlsx
    14.6 KB · Views: 6
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..
 
You will need to explain further how the dates should be re-aligned, as I'm still confused.
 
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.
Click to expand...
 

Attachments

  • Sample-chart LM_update.xlsx
    15.3 KB · Views: 8
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.
 
You must log in or register to reply here.
Back
Top