I found a simple MACRO that I managed to apply to some similar data which allows you to label data points without adding every point as an individual series here http://support.microsoft.com/?kbid=213750. Which will help with some of it. I can't help on separating series but if you just copy the graph and then change the links that should stop you having to do all the minor tweaking.
If not I find that PAST is usually better for things like this.
I've just emailed you (uni address) becuase my comment got too long!
I think what you want to do can be done in PAST fairly easily if I understand what you're doing (though not to figure level quality as is true with all PAST output - but good enough for examining your data) so I've just emailed you instructions on how to do what I think you're trying to do. I've never found a way to do it in Excel and I'm not sure how I'm going to generate final figures for my thesis/publications (ha ha) yet. It might be that the chart labeller addon will make you happier (I've not tried it yet but it does look like it does what you're trying to do (and me, if it comes to it!)
Also, on an ENTIRELY different note, I finally saw "Ironman" this weekend and the moment the line "In a cave" happened, I knew, just knew where it was going to end.
probably not helpful...dr_alycatJune 10 2008, 14:42:08 UTC
but have you considered using a more powerful stats program, like Stata or SPSS? Often they can do much more work for you given only raw data. I like it when the software does the work! Just a thought.
I don't know how much it helps to hear people say YOU'RE NOT ALONE... but you're not! dissertating sucks really (really... really) bad, and it always seems to feel like you're so much worse at it than you ought to be (or than others are) but you're not. You have a passion for science (and science education) and THAT is going to take you very far in any career in this domain.
Re: probably not helpful...innerbratJune 10 2008, 14:44:53 UTC
*cries* But I really am behind! I really am bad at it! No one ever believes me! And I know how futile it is to keep saying that but people telling me I'm not alone right now makes me want to accuse them of not understanding my comprehensive level of fail.
I will try and eat at teatime, promise. I've had biscuits!
Comments 33
I found a simple MACRO that I managed to apply to some similar data which allows you to label data points without adding every point as an individual series here http://support.microsoft.com/?kbid=213750. Which will help with some of it. I can't help on separating series but if you just copy the graph and then change the links that should stop you having to do all the minor tweaking.
If not I find that PAST is usually better for things like this.
Reply
Blegh, that macro looks great, but I can't get it to work.
Reply
I think what you want to do can be done in PAST fairly easily if I understand what you're doing (though not to figure level quality as is true with all PAST output - but good enough for examining your data) so I've just emailed you instructions on how to do what I think you're trying to do. I've never found a way to do it in Excel and I'm not sure how I'm going to generate final figures for my thesis/publications (ha ha) yet. It might be that the chart labeller addon will make you happier (I've not tried it yet but it does look like it does what you're trying to do (and me, if it comes to it!)
Reply
Reply
I don't know how much it helps to hear people say YOU'RE NOT ALONE... but you're not! dissertating sucks really (really... really) bad, and it always seems to feel like you're so much worse at it than you ought to be (or than others are) but you're not. You have a passion for science (and science education) and THAT is going to take you very far in any career in this domain.
Oh, and do keep trying to eat :)
Reply
I will try and eat at teatime, promise. I've had biscuits!
Reply
Reply
Reply
Reply
*hugs it tight*
Reply
Leave a comment