Sorry I'm confused. I opened your workbook. I changed the parameter and selected flow changed. What else were you hoping would happen? You want the Intrusion Point to change when the parameter is changed? In what way? So if the select flow is 51, what should the intrusion point change to? More importantly, what is the math to calc the change.
Sorry, I should have explained this better. Changing the flow parameter will move the symbol along a line of best fit made for a larger dataset. Equations are as follows (Q = flow):
Mainstream: = -5.37978E6*Q^3 + 0.019355*Q^2 - 24.5677*Q + 7038.05
Ebey = -3.71063E6*Q^3 + 0.0220397*Q^2 - 38.3201*Q + 16854.5
Perhaps there would be an easier way to make the annotation change... by somehow applying these formulas directly in the annotation and based off the parameter?
Now I actually tried that before, but ran into two problems:
- If I set the annotation to a point when the parameter is equal to 500, then it annotates until I change the parameter. If the parameter becomes 501, then the annotations disappear.
- While I am only referencing two points in the sample, the full workbook is referencing four points. Creating four point annotations and getting the text to line up well is complicated at best. What makes matters worse is that the relative text size changes when moving between a sheet and a dashboard.
Do you have any recommendations for dealing this these problems?
So any thoughts on what do do here? Or perhaps is there anywhere that I can provide more information?