Basic Excel feature request
This seems like it should be simple. I want to be able to make a worksheet full of data and charts showing assorted data summaries. I want to be able to cut copy and paste that into a new worksheet, and plug in a new day's batch of data. (So far, no problem). I would then love to be able to click a button that updates all of the graphs on the worksheet to the data in the same location on that worksheet.
I suppose I could probably use a template to do this, but A: don't wanna, B: I do make enough day-to-day changes to my data analysis that I would like to be able to easily choose between how I analyzed the data yesterday and how I analyzed it a week or three months ago, and C: I don't have enough faith in Excel to actually have gotten that far right.
The really frustrating thing is that this has gotten significantly harder since I upgraded to 2007, which is otherwise a significant improvement. Whereas before it could be accomplished with a right-click-left-click-enter or a right-click-tab-left-click-repeat-enter, it's now an complicated process that takes a couple minutes for each chart, which is really frustrating when I'm trying to update a dozen charts or so per worksheet while catching up on a week or two's worth of data.
[/vent]
I suppose I could probably use a template to do this, but A: don't wanna, B: I do make enough day-to-day changes to my data analysis that I would like to be able to easily choose between how I analyzed the data yesterday and how I analyzed it a week or three months ago, and C: I don't have enough faith in Excel to actually have gotten that far right.
The really frustrating thing is that this has gotten significantly harder since I upgraded to 2007, which is otherwise a significant improvement. Whereas before it could be accomplished with a right-click-left-click-enter or a right-click-tab-left-click-repeat-enter, it's now an complicated process that takes a couple minutes for each chart, which is really frustrating when I'm trying to update a dozen charts or so per worksheet while catching up on a week or two's worth of data.
[/vent]