Moving charts to another sheet
Posted by Bill on October 14, 1999 4:23 PM
You people are fantastic.
I have been teaching myself Excel,(with help, of course), but there are some roadblocks I run into. This is one. I built a sheet for my brother, and made a fundamental mistake. I didn't think ahead. I put a couple of charts and graphs in the same sheet as the data...I never figured he'd need over a hundred entries. So I thought I could just move the charts to sheet 2. I cut and pasted it. So of course all my cell references are out of whack. Dumb. It had been so long since I made it, I was writing down formula's and cell references when I thought "there must be an easier way". I've learned, thanks to Chris and Ivan, there usually is. Am I wrong? If I am, I can still hack it out, and learn my lesson. PLAN ahead.