I am running xl2003 and WinXP SP3. Given a chart, you can highlight one of the plotted series and then click on a specific point. A form pops up (called "Format Data Point") which allows you to change point color, marker, etc. I wish to be able to click on a single point in a chart and have a VBA procedure fire up that will allow other things to happen to the particular data point (like change its value).
The workaround is to change one of the point attributes and then when all the changes are done run a procedure that examines the data series for those changes and take appropriate action. This should work but it is a band aid.
Any thoughts?