Circular Graphing & Trend Extraction

Drolkcaj

New member
Joined
May 23, 2015
Messages
1
Reaction score
0
Points
0
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 have attached a screenshot of the current problem.
-the blue lines and dot are what I currently have as data.
-the red line is what would happen if the first point (earliest) is linked through 00:00 to the last (latest) point.
-the yellow line is if the curve that was produced was of best fit.

I am wondering how to get both of these two lines 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 (green line) 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 attached the worksheet below.

Regards,
Jack
 

Attachments

  • Time Taken.xlsx
    192.6 KB · Views: 20
  • Untitled.jpg
    Untitled.jpg
    90.8 KB · Views: 24
Back
Top