I have this spreadsheet (attached) that does this:
User inputs "Entry Point X & Y" and "Exit Point X & Y". The user is inquiring what every point along that path is, every "Calculate X,Y every" feet. The table automatically lists every X & Y along that path, every Z number of feet (Z being user specified earlier).
The table automatically checks the first and last value, as they should be the same as the user input value.
Everything seems to work fine. My formulas check and all is well.
However, to give our engineers a warm & fuzzy, I wanted to add a "check" diagram. The first chart here plots the user input X&Y and gives the trend formula. The second chart plots all the points as calculated in the table. Here's where things go wrong.
The chart refuses to use the same Horizontal Axis labels as the first chart and puts them at REALLY small increments. Then the trendline equation doesn't match. I've even tried the trick where you change the Number format of the equation to include a lot of 0's but still the formulas don't change (other than expanding out the decimal place). Please help! This is my last step to making this tool work!
Bookmarks