Chart integrity degrades when hiding

[timmtamm]

I have a macro that is hiding rows. The charts and the information that is on them is included in these rows. These are XY scatter charts. I have changed the properties of the chart to "don't move or size with cells." However, it still isn't completely working.

If a group of cells is hidden by the macro and then I make a new worksheet by right clicking the worksheet tab and selecting "move or copy," and then the macro unhides the same group of cells, the equasion for trendline and R-Squared value dissapears. Instead, there are "x value" data labels on each point of the line.

After some time and repetition of this, I even had on chart take on the properties (including source information) of another chart in the same worksheet.

Can this problem be fixed?

Please Login or Register  to view this content.

[timmtamm]

I thought that this might be complex enough that I should include a file for the example. So here is a simplified Excel file with the charts and macro. Go ahead and take a look.

[timmtamm]

bump, no response.

[Andy Pope]

The trend line label does appear to vanish when copying to another sheet when the original is not displayed.

I guess the fix is to unhide the cells prior to copying sheet and then hide on new sheet.

[timmtamm]

Yea, I can unhide and then rehide, but I was hoping there might be a more automated way of fixing the problem.