got it…excatly what i was looking for
The easiest way I found out is to insert a row or column before the last set of chart reference data. That extends out the chart reference by one set. Then take the previous month’s data, copy it in the new inserted area, then input new data into the “old” column. Pretty much what I do for all of my tracking sheets which are hit by dozens of graphs. Once you set up the data in correct columns or rows and can copy/past large ranges, it becomes a pretty ficking easy exercise. All of these guys at work spend hours updating sheets for management reports. They continually wonder why I produce 10x as much data and charts in an hour compared to their 10 hours.
Spierce - not sure I follow what you’re saying, but it sounds intriguing. Could you post an example on-line (rapidshare, megaupload, etc.)?
Let’s say you have data populated in A1:AB4. 1 row being the dates, the remaining 3 being data that is to be charted. The columns represent a new month of data. The chart references A1:AB4. This month, you need to enter new data. That data will fit into AC1-AC4. However, you need the charts to reference AC1-4 without referencing it. Thus, you highlight AB:AB and insert a column. That’ll insert a blank column in AB:AB, with the old month in AC:AC. The chart will automatically reference A1:AC4. Now, you take the the “old” month column (which is right now AC:AC) and put it back into AB:AB. Then you enter the “new” month data into AC:AC. Viola, no need to update the charts. It seems a bit cumbersome, but is actually pretty damn easy. The biggest part is making sure certain cell references don’t “break” because you cop the data back. However, if you set your sheet up properly this can cut down update times to a bare minimum. I am being a bit lazy by not making a spreadsheet, but if I need to, let me know.
TJR Wrote: ------------------------------------------------------- > TheBigBean Wrote: > -------------------------------------------------- > ----- > > TJR Wrote: > > > -------------------------------------------------- > > > ----- > > > Speaking of not using the mouse…how do you > > move > > > the cursor to the worksheet tab (to label) > > using > > > only the keyboard? > > > > Do you mean more than ctrl + page up / down? > > Yes. How do you get the cursor in the tab to > rename it. The default for excel is Sheet 1, > Sheet 2, etc. so how do you rename without the > mouse? > > > > > > Also, how do you space out all the columns > > evenly > > > without the mouse? Currently I highlight the > > > whole worksheet (ctrl A) and double click on > > the > > > border of a column. > > > > Try Shift space bar, alt o,c, return Then pick > a > > number > > That can work but its hard to know the exact > column width to use, especially if you have > columns with different amounts of data. > > Alphabound gave a good one (much appreaciated) but > I was hoping I didn’t have to use a macro b/c i > use a several cpus besides my own. Hey TJR, I have run into the same issue (unfortunately). Sometimes I have to bounce back and forth between coworkers pc’s to help out. If you carry a flash drive I can help you get something that would work. You would have to connect the flash drive and open a workbook containing the code, though. The code would auto-execute, however it may be more than what you’re looking for. Edit: I have a way of making things complicated, but it comes in handy when you run across a complicated problem.