Quote:
Originally Posted by Waterdog111
Looks like you have the tracking mosture down to a science. Id like to learn to be that exact!
|
Ah, well Excel is $49 for home use. So I use Google Sheets. LOL
Ah, well I guess there's a free Microsoft X version. Not sure I feel like learning it. LOL
I use a very basic line graph and have learned to fix a few gotchas. Like skipping a data point or getting calendar days to enter automatically.
I like tweeking it so it's pretty also. I could be avoiding studying Français.
If you want I can post what I do with some screenshots.
One hard thing to find was how to skip data points and still have a continuous line on the graph.
That's in Chart Editor>Chart Style>Plot Null Values
I get the dates by entering the first date, then in the next day I enter the function =B5+1. Then copy that function all the way down. It even ends the month on the correct day. B5 is the column the dates are in.
And the phone trick, I get the goog sheet in my phone.
Pick the 3 button menu > Available offline >Share & Export > Add to Home screen.
That allows access directly to that file. It will probably showup in your last phone page where you can move to any page or add it to a group by dragging it over an existing file icon. That will make a group icon.
I have one icon with about five files in a group now on my start page.
cheers!
~Henry