OT: need help graphing with Excel

[jsl6v8]

Well I am making charts of my 5 tanks and how much mag/calc/alk I am dosing have have it sorted by week so it looks like
Week
Tanks 20g 37g 55g 90g 120g
mag xxx xxx xxx xxx xxx
calc xxx xxx xxx xxx xxx
alk x.x x.x x.x x.x x.x

Week
Tanks 20g 37g 55g 90g 120g
mag xxx xxx xxx xxx xxx
calc xxx xxx xxx xxx xxx
alk x.x x.x x.x x.x x.x

but when I try to use the graphing function it won't let me graph it as x as the week and y as the number value and the stat points as 20mag, 20calc, 20alk, 37mag, 37calc.... ect ect.

I know the easiest way to do it is just to do each tank or each peram seperately but I really just want to be messing with 2 spreed sheets and 2 graphs (one for measurements and one for dosing). If anyone thinks they may know how to do this if they had their hands on the spreedsheet I'll be more than happy to email it to you. Any suggestions?

 

[Bacchus_fl]

The only problem with doing it this way is that each graph will be confusing to read since there will be 3 lines for each tank. That means 15 lines per graph.


All you need to do is set up your x axis as the week and your y axis as a ppm range (probably just use auto range). Then set up your spread sheet to read like this:
Week 1 - 2 - 3 - 4 -etc
20G Mag xxx xxx xxx
20G Calc
20G Alk

37G Mag
37G Calc
37G Alk

etc
etc
etc

You can e-mail it to me if you would like and I will set it up for you. I can't promise it will be right away but I should be able to have it done by the end of the weekend. Not sure but you maybe able to set it up so that you can click on and off each catagory so that it wouldn't clutter the graph. You could also build in a link that will flip back and forth between graphs so that you could have seperate graph for each tank but make it easier to navigate.

Let me know what you decide!

Jason

jwhopson@hotmail.com

 

[Pterodactyl]

Are you trying to do a bar graph that shows each tank and the parameters?

 

[jay24k]

That seems tough to do. I would search for graphs that utilize 3 independent variables. I understand how it should work but I don't know if Excel can do it.

 

[jsl6v8]

I'm doing a line dot point graph, I know excel can do it because I've done it before just not sure how to do it anymore, its funny I have a class in college just over excel and how to use it, I had a class over programming functions and other things in excel, but I can't make a simple graph work like I want.

 

[jsl6v8]

I think I'll just bust my ... dreams, and do it all as seperate tanks, I know I should be able to make them all seperate graphs then incorporate it as a universal graph, I'll have to look at it again but I'm to lazy right now. Thanks for the offer Jason, if I can't figure it out or can't get it like I want it I'll send ya an email. Maybe I'll do it in access I think I remember how to do it in there. I know how to do it in quickbooks I think but I alas I nolonger have a copy of quickbooks.