I need to setup a spreadsheet to enter data to from my findings o.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to log mu findings into an excel spreadsheet and then graph the
results I am not sure if there is a specific spreadsheet format I am please
help
 
One basic way to set this up:
All you need to do is make a table and then click in it. Then, Run the Chart
Wizard. You can access it from Insert | Chart.
Example, if I want to create a chart based on how much produce my gorcery
store sells in a month, I would put the types of produce down one column,
like this:
Apples
Pears
Cherries
Oranges

Then, I would put the Months of the year across a Row:
Jan Feb Mar Apr ...

This would create a rectangular area for your data.

Check out:
http://peltiertech.com/Excel/ChartsHowTo/index.html

This will give you a lot of info on building charts in Excel.

tj
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top