I currently have a multi-tab spreadsheet. 1 Sheet contains all data for the other tabs, which are graphs showing dollars by department.
On each graph I have charted out the data: dollars and goal plus a trendline for the dollars. So, each graph has three element plotted. The x-axis is the week ending date (friday's) and the y-axis is dollar amount.
I want to add the ability to do a little trend line analysis. The user can type in two dates, which are then converted to valid friday dates (closest friday). This functionality is done. Then, I want those dates to be taken and trended on each chart. The point is that the user can trend out different areas of the graphs so if they want to look at the last quarter, last fiscal year, last month... all the user needs to do is enter in the 2 dates and the smaller trendline is shown.
I found an example online stating to use an intercept based off a match that returns the row number. Such as date 9/28/07 is row 390 on the data tab and date 1/18/08 is row 406 (I have the match working fine).
I cannot get the intercept to work. It won't work. I'm not even sure what I should be using or how to get the match to convert the xvalues.... no clue. I'm lost on this one. Any and all help would be appreciated.
cfp
On each graph I have charted out the data: dollars and goal plus a trendline for the dollars. So, each graph has three element plotted. The x-axis is the week ending date (friday's) and the y-axis is dollar amount.
I want to add the ability to do a little trend line analysis. The user can type in two dates, which are then converted to valid friday dates (closest friday). This functionality is done. Then, I want those dates to be taken and trended on each chart. The point is that the user can trend out different areas of the graphs so if they want to look at the last quarter, last fiscal year, last month... all the user needs to do is enter in the 2 dates and the smaller trendline is shown.
I found an example online stating to use an intercept based off a match that returns the row number. Such as date 9/28/07 is row 390 on the data tab and date 1/18/08 is row 406 (I have the match working fine).
I cannot get the intercept to work. It won't work. I'm not even sure what I should be using or how to get the match to convert the xvalues.... no clue. I'm lost on this one. Any and all help would be appreciated.
cfp
