Friday, 19 October 2007
EXCELlent?
I don't remember having used excel to draw graphs before, I certainly knew that you could but never needed to. I used to use it at my previous job for creating very, very simple tables to record information but that was it. Having to create graphs for science was quite challenging and I found that the "help" didn't really help either, it was far too complicated and didn't really answer my query (or do I think that just because I found it complicated?!). I managed to complete the task in the end and created a pie chart, bar graph, a couple of scattergrams (I enjoyed doing those!) and an attempt at a histogram. The histogram proved difficult as there wasn't a function on excel which enabled me to put in the data and create one, so I had to resort to adapting a bar chart. I still don't know if it is right. So after all that I now feel confident tackling simple graphs and data on excel, although I can't remember how to make it do sums, I'll have to look up how to input a formula and have a go.
Subscribe to:
Post Comments (Atom)
1 comment:
Make it do sums... I take it you mean add a list of figures.
Highlight the figures and an additional empty cell at the bottom (or side, if you are working horizontally). Then click the Sigma (∑) symbol.
Else put the following in yourself
=sum(startcell:endcell)
Post a Comment