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
Bookmarks