patrickmuldoon99
Active Member
- Joined
- Jun 27, 2006
- Messages
- 345
Hello All
When I drag a point in a line graph, excel usually updates the cell reference accordingly based on how i've altered the trend shown.
When I try and drag a point on a graph that feeds off formulae, excel brings up goalseek and asks what cell I would like to change to achieve the value I have altered the graph to be.
This is fine, what I wanted to know is whether I could perhaps set up an on_change event on my graph so that goalseek could be automated (as the cell to change is always the same). Basically, I don't want the goalseek thing to crop up, I just want excel to realise that it should conduct the goalseek on a given cell.
Has anyone got any bright ideas on how this could be done, I would be eternally grateful!!
Cheers all, Patrick
When I drag a point in a line graph, excel usually updates the cell reference accordingly based on how i've altered the trend shown.
When I try and drag a point on a graph that feeds off formulae, excel brings up goalseek and asks what cell I would like to change to achieve the value I have altered the graph to be.
This is fine, what I wanted to know is whether I could perhaps set up an on_change event on my graph so that goalseek could be automated (as the cell to change is always the same). Basically, I don't want the goalseek thing to crop up, I just want excel to realise that it should conduct the goalseek on a given cell.
Has anyone got any bright ideas on how this could be done, I would be eternally grateful!!
Cheers all, Patrick