Excel and I are having a -- discussion. So far I'm not sure who's winning, but I really don't think it's me. Finding myself a course in Visual Basic is looking to be more and more necessary for the sake of my hair. And it's not even anything major, it's simply knowing that something *must* be possible, but having no real clear idea how to make it happen, and not knowing where to find the answer. Half the time I'm not sure I'm asking the right *question*! AAAAAAAHHHHHH!!! ::jumps around fisting hair::
Right, now that that's out of the system... *sigh* I finally found how to link Excel charts to PowerPoint so things update automagically, without having to strip every chart (20 at last count) into seperate files. Don't know why it worked this time when it hasn't previously, but so be it. Too bad that wasn't the question I was asking at the time, stupid Help file. I'm still trying to get my base charts to update themselves when I enter data - they're rolling 12 month productivity charts, and the chance of errors creeping in is higher than I like - I get distracted, forget to update a chart's source data, and suddenly I'm getting people panicked far out of proportion to the issue. Not worth it. Plus I'm lazy, which is funny when you consider how hard I'm trying to make this work. Oy... I'm now trying to set Labels and use Offset functions, but for whatever reason I'm not getting them to work in the 20-chart file, although they work successfully in a single chart test. I'm sure it has to do with do with Excel 2003 trying to add the file name to the label in the data line's function. Ugh, I just typed that and I'm not even sure what I'm talking about. Feh... I'm starting to think this might all work better if I just start from el-scratch-o. It's entirely possible I botched a setting somewhere, threw in a hidden function or something, in some previous attempt to make the DAMN THING WORK!!
...And if not, I'll just have to stay secure in the knowledge that many things are possible if one just plays Hide The Column.