Hi All,
I am making a spreadsheet for work in terms of tracking average times at certain times of the day.
This allows me to change the origin and destination and the graph automatically changes.
I have a few problems though that I hope someone more experienced than I am could help with.
I am wondering how to get two points to automatically connect to create a "circular" graph (not sure what to call it)
I was then also hoping to be able to input a time and it would extract the time taken from the yellow line to give the predicted time.
I am hoping to do this without the need for macros though if its the only option then It'll have to do.
If someone could help me that would be much appreciated.
I have a spreadsheet available but wasn't sure how to upload it.
This problem has been annoying me for months now and noone has been able to give me and answer and cannot find anything online - so resorted to this.
Regards,
Jack
I am making a spreadsheet for work in terms of tracking average times at certain times of the day.
This allows me to change the origin and destination and the graph automatically changes.
I have a few problems though that I hope someone more experienced than I am could help with.
I am wondering how to get two points to automatically connect to create a "circular" graph (not sure what to call it)
I was then also hoping to be able to input a time and it would extract the time taken from the yellow line to give the predicted time.
I am hoping to do this without the need for macros though if its the only option then It'll have to do.
If someone could help me that would be much appreciated.
I have a spreadsheet available but wasn't sure how to upload it.
This problem has been annoying me for months now and noone has been able to give me and answer and cannot find anything online - so resorted to this.
Regards,
Jack