I know next to nothing about excel so I`m asking the hive mind for assistance. I need to plot a graph that has a value between 0 and 1000 and... Who's Online | Find Members | Private Messages
Questions
Quizzes
Articles
My Journal
Forums
Quests. | Journs. | Gen. | News | Quiz | Links | TV | Music | Movies | Games | Sports | Sug. | Lit. | Jokes | Artcls. | Newb | O.S.
From the Journal of snarf | mood: Good

I need help making a graph in excel

Back to Thread List
Bottom Last Post

19 days ago - Saturday 12/30/17 - 2:53:00 PM EST (GMT-5)
I know next to nothing about excel so I'm asking the hive mind for assistance.

I need to plot a graph that has a value between 0 and 1000 and show it over time. Hopefully the picture in the next post explains it better.

It's for the settleometer test. That's where I pour mixed liquor(poop water) into a jar and record how much it has settled over time.

Anyh assistance will be appreciated.

19 days ago - Saturday 12/30/17 - 2:54:27 PM EST (GMT-5)


19 days ago - Saturday 12/30/17 - 2:56:17 PM EST (GMT-5)
excel is very intuitive and you just need to enter all the data
make one axis time and one the measurements and put all dat data in there and then just press the button to turn it into a graph and play with it
19 days ago - Saturday 12/30/17 - 2:57:07 PM EST (GMT-5)
Is that poop at the bottom?
19 days ago - Saturday 12/30/17 - 3:04:47 PM EST (GMT-5)
Poop and bugs. Collected at the last point before the clarifier.
19 days ago - Saturday 12/30/17 - 3:06:45 PM EST (GMT-5)
On Saturday 12/30/17 - 2:56:17 PM skyfish wrote:
excel is very intuitive and you just need to enter all the data make one axis time and one the measurements and put all dat data in there and then just press the button to turn it into a graph and play with it

I don't know how to make it display only one day's data at a time. I'd like to be able to click through each day so we can watch the daily trend over time.
19 days ago - Saturday 12/30/17 - 3:07:48 PM EST (GMT-5)
well this is far too specific for my drunken know nothing self....


rag? bird???
19 days ago - Saturday 12/30/17 - 3:09:57 PM EST (GMT-5)
The clarifier works the same way as the jar. Poop goes to the bottom and clear spills over the top.
19 days ago - Saturday 12/30/17 - 3:10:53 PM EST (GMT-5)
I could do it, but I can't explain how to do it without actually doing it.
19 days ago - Saturday 12/30/17 - 3:13:47 PM EST (GMT-5)
So I'll give you my email and you can send me the template.

I'll tell people you're cool if you do.
19 days ago - Saturday 12/30/17 - 3:15:12 PM EST (GMT-5)
Or better you can walk me through it when we're both at a computer. I'm actually running the test now.
19 days ago - Saturday 12/30/17 - 3:16:19 PM EST (GMT-5)
We could Facebook live you could put a mask on
19 days ago - Saturday 12/30/17 - 3:17:17 PM EST (GMT-5)
I'd like to know how to do this rather than just have it given to me. I've watched a few videos on you too but I can't find what I specifically need
19 days ago - Saturday 12/30/17 - 3:18:14 PM EST (GMT-5)
In excel name your x and y axis
Enter the data
X. Y.
1. This much poop
2. This much poop.


Then at the top there is a tab that will create a variety of graphs with that data.

I wish I was at a computer because it’s very easy
19 days ago - Saturday 12/30/17 - 3:19:36 PM EST (GMT-5)
I can't remember how to do it, I'm just good at screwing around and always manage to figure it out.
19 days ago - Saturday 12/30/17 - 3:29:26 PM EST (GMT-5)
On Saturday 12/30/17 - 3:18:14 PM jstckndamale wrote:
In excel name your x and y axis Enter the data X. Y. 1. This much poop 2. This much poop. Then at the top there is a tab that will create a variety of graphs with that data. I wish I was at a computer because it’s very easy

So if I do that I can click on the row number and it will display that day's data only?
19 days ago - Saturday 12/30/17 - 3:32:50 PM EST (GMT-5)
On Saturday 12/30/17 - 3:10:53 PM CuckingFunt wrote:
I could do it, but I can't explain how to do it without actually doing it.


Same.
19 days ago - Saturday 12/30/17 - 3:33:27 PM EST (GMT-5)
uh yeah....me too
19 days ago - Saturday 12/30/17 - 3:39:51 PM EST (GMT-5)
So time is my x axis and settled amount is my y axis. I'll try dicking around with this tomorrow.



You need to be logged in to post a reply

New to YT? Create a Free Account ~ Have an Account? Log In

Back to Thread List
Top

 
Edit