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
Bookmarks