I have a chart which contains data labels where I have gone in an manually changed the labels to reference specific cells. The references to the cells are locked using "$" before the column and row indicators so I expect them not to change. However, whenever I hide a row (or set of rows) the cell reference changes (even if I'm not hiding the row that is being referenced). Anyone else have this issue?
Bookmarks