Once again Microsoft has released a major upgrade of it's Office suite of products. For the most part I really like the improvements. But God damn if they haven't screwed me in a major way.For both my day job and my consulting work, I generate a lot of charts. A LOT. Usually the analysis requires a series of identical charts each summarizing different pieces of data (like one for SAT scores, another for ACT scores, yet another for GPA, and so on). Typically, the charts I create are the result of painstakingly trying different ways of portraying data, such that the end user can quickly "see" what is going on. The process starts with hours of generating the first chart to get it just right. And then, once I have it laid out exactly the way I want it, I make a copy of that chart, like so...
Once I have the copy, I need only click on the chart, and select the next series of data, like so...
...and viola, all I have to do is change the chart title and axis labels and in about one minute (as opposed to another hour or so), I have the next chart in the series...
This time-saving strategy doesn't work with Excel 2007.
I am completely screwed.
5 comments:
Yikes!
Ok, so I am not an Excel guru, but are you SURE they just didn't change how this was done?
I'll ask around here at work and see if I can get a work-around or the dirt.
Its possible Lach; I'm still finding my way around this new version. I did what I have always done in the past, and only HALF of the formatting stayed when I used new data.
Um, yeah, I'd be really interested in this too.
I also will be royally screwed if this is the case.
We haven't upgraded yet...
I'm not upgrading my home PCs until I get it figured out.
Post a Comment