Hi,

I have a challenging request considering my poor knowledge regarding excel graphics but i believe there are some people here who can help me with below problem.
I have a workbook about a highway project and i feed worksheets with completed sections of the project every week by adding "kilometer" intervals. In other words, i have a table which shows incomplete and complete sections of a 100km highway.

My problem arises when i consider adding some visualization effects into the worksheet1. I want to draw a spline in Excel representing to be 100km. I want it to start with km "0" and end with km "100". Also, for completed sections, spline should be green and for incomplete sections spline should turn into red. Is this possible? If it is not, what could be the alternative solution?

Any help appreciated.