Following the advice posted at http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/, imagine I have hundreds of calculated fields resulting in a name, and I want for each row to have a figure correspondent to that name.
The technique of attributing a getChart formula to an image (or the Camera Tool), as described, works only if the function getChart has only absolute references (p.e., $A$2), not working if it has one relative reference (p.e., A2) - which would allow me to paste the image/camera several times in front of the names, and it automatically updating for everyone. Does anyone knows how can I handle that?
Best regards, Aires
The technique of attributing a getChart formula to an image (or the Camera Tool), as described, works only if the function getChart has only absolute references (p.e., $A$2), not working if it has one relative reference (p.e., A2) - which would allow me to paste the image/camera several times in front of the names, and it automatically updating for everyone. Does anyone knows how can I handle that?
Best regards, Aires