Database Line Graph wanted

JimL

JimL

I know just enough to be dangerous
Mar 28, 2009
406
0
0
Silverdale, WA.
Hello;
I'm new to this site and I'm not sure where to look, what I'm looking for is a line graph to plot my progress as I do a fishless cycle on a new tank. I'm able to do it on graph paper but thought it would be nice to be able to do it on my computer.
I'm testing the water 3 times a day, 9am, noon, 9pm. I add ammonia after the 9am testing. I'm using a API master(fresh) test kit. I'm testing, Ammonia, Nitrite, Nitrate, pH and High pH.
If this type of database already exists, please point me in the right direction, if not please do me a flavor and write something up. Doesn't need to be anything fancy, just something so I can watch the process work.
Thanks
Jim
 
Hi Jim.. it might help get you better responses if you mention the software applications you have installed that you're already comfortable using. We have a lot of computer-savvy members who could set up something for you in no time at all.

Personally, I'd get a kick out doing this the old fashioned way with graph paper. Here's a decent comparison graph you could also just enlarge and print. Then add your own little plot points manually.

n-cycle.gif
 
My computer came with MS Office, but I'm not picky. If I had to get some other software that's ok.
 
Office is fine. Just put the numbers into Excel in a table and get it to plot a chart.
 
+1 on the Excel, very versitile, Great for graphing aid, a decent basic Cad program, works well as a logger, and oh yeah it is also a great spreadsheet package.
 
Excel would work great for this.

I would also recommend using the Google Docs Spreadsheet application. That's what I've been using as log for my tank and it works great. Just plug in the numbers and the chart will update itself. It also makes it easy if you start having problems; you can make the document public and post a link to it so someone helping you can get an idea of the history of the levels. Plus, the best part of it is that it's free.
 
KarlTh said:
Office is fine. Just put the numbers into Excel in a table and get it to plot a chart.
Click to expand...

putting in the numbers is where I get lost, I don't understand spreadsheets, or tables.
 
This isn't really the place for an Excel tutorial, but in brief, make each row a measurement time; make each column something you're measuring; the first three days might look like this:
.........NH3 NO2 NO3 pH KH GH
0900
1200
1500
0900
1200
1500
0900
1200
1500

Like that. Then put the numbers in. Excel will be able to turn that into a graph very easily.
 
You must log in or register to reply here.
AquariaCentral.com
Top Bottom