I need to place drawing objects on a 3D Column chart by using the coordinates of the data-point columns.

I have found the following web-page explaining very closely to what I want to do in Example 15-3.

http://www.awprofessional.com/articl...74498&seqNum=2

I can get this to work exactly how I want it to for non-3d column charts, but when I try running it on any 3d column charts, it returns the #VALUE! error value.

The concept is exactly the same. I don't know why a 3d column messes up the function.

Is there anything that can find coordinates of data points of 3d columns?
or can anyone think of another way to do this?

Thanks