Thanks. I've tried sheets. Its actually what I use to keep track of stuff. Problem I have is it stacks the results so for instance if I have 4 days at 8.6 and 1 day at 9 it stacks the 8.6 days and the graph is higher than the 9. I would like to have it by date or at least in sequence with each reading being individual and not overlaying another day with the same result. I'm pretty much an idiot when it comes to using office type of software so its probably me.
I'm trying to convert the results as shown above using sheets without stacking the numbers that are the same. As stated I'm really incompetent with this kind of stuff. I have an old copy of office 2010 installed but am more clueless with excel than sheets
Ya tried that and it still stacks them peaking the 8.6 higher than 9
Will probably check later. I'm not much a YouTube fan. It's an old guy thing
I don't know. I thought maybe it was the way I set the sheet up from the beginning. If I start an new one and just enter dates and numbers like you did and select the dates then insert chart I get the following which I have no idea the meaning. If I select just the result vs date I get the same screen.
So Sheets will do what you're asking, I've just entered some arbitrary dates and dKH values it automatically map them out at even intervals on a time line chart for you.
Ya tried that and it still stacks them peaking the 8.6 higher than 9
Will probably check later. I'm not much a YouTube fan. It's an old guy thing
Thanks for everyone's help. I'm going to go crawl back under a rock where I'm comfortable. We don't have to deal with y and x axis there. LOL I cant even find a place to add or change a Y axis in sheets
There is no Y axis available unless Series is Y which makes no sense to me but even if that's the case it says my selection of the alk row is invalid.
Click on the chart so it's highlighted and you should see these dots appear, click them, then select edit chart.
The chart editor should appear on the side of the screen and look something like this:
Now you can select he X-Axis data then the Y-Axis data.
As people have mentioned just input your data into excel and do a line graph. As for the same results stacking, as long as one of your axis is dates that should be impossible as dates don’t stack. This could be an issue with your formatting of the dates. Graphing x as a date and y as your result value should alleviate this issue entirely.Does anyone know of software that can be used to input my digital test result numbers and convert them into a graph? I do not use any monitors but want to graph my alkalinity results just looking for trends.
Free would be awesome. I would prefer to us PC. I'll also mention I'm somewhat tech challenged so easy is good
