Dynamic references in diagram source data?
 

Have encountered problems when copying and pasteing diagrams and their source
data areas. I wish to exclude the $ signs in the source data formulas in
order for the diagrams to retrieve data from different areas in the same
spreadsheet. This however seems impossible because excel automatically
reinsert the $ signs when I manually remove them from the source data
formulas.

Any thoughts? Thanks.
--
Olzki