Thread: Chart integrity degrades when hiding

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?

Thread (with macro code included) is also in this other forum.

http://www.excelforum.com/excel-prog...ml#post2049662

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.