[Solved] Date Range Help Medical Record

dsosterman · Post by **dsosterman** » Sat May 21, 2011 6:49 am

Hi. OK, I am new here and already asking for free help. A Leukemia forum has generously posted a database that allows patients to track their blood chemistry. Data entered on the spreadsheet is populated to graphs. it's a very useful tool. The problem is that the graph date range is 1/2006 through 1/2011. A lot of us would like to live longer, and most of us already have, but you would never know that from our graphs. We would like to keep the 1/06 low end of the range, and we would like to extend the outer range by 10 years, if not indefinitely. I have struggled with this for days in both Excel and Open Office Base. I have not been able to change the date range. Is there a good Samaritan out there who can help me out? The material is not copyrighted. And I will upload it to the forum that it came from if I can get this fixed. Help would be appreciated. The database is attached. Thank you. David

Ooops, I can't attach the file. It is 231 KB.

My email address is: <removed by moderator V.>

Thank you again

edit this topic's initial post · Post by **Villeroy** » Sat May 21, 2011 11:13 am

Remove most of the data so the problem is still reproducable with a small set of data.
Use a hosting service such as http://www.mediafire.com/ for big files.

dsosterman · Post by **dsosterman** » Sat May 21, 2011 2:30 pm

Thank you for your response. Is there an email address I can use for a DropBox transfer?

David

edit this topic's initial post · Post by **Villeroy** » Sat May 21, 2011 3:17 pm

No email.

dsosterman · Post by **dsosterman** » Sat May 21, 2011 7:01 pm

Hello again. I have posted two files at Mediafire.
Records.xls is the original blank database.
CLL Log.xls is the same file with minimal data entered. You will see that the data populates to the charts, but that the date range is a problem
My thanks to all.
David, with thanks

http://www.mediafire.com/?jid0blyve24nhvj

And since my download only produced one file, here are the two individual urls:

http://www.mediafire.com/file/jid0blyve ... %20Log.xls

http://www.mediafire.com/?53rbnqh2m47u421

E-mail removed, nobody will reply by mail and it will avoid spam bots to register your address (Hagar, Moderator).

edit this topic's initial post · Post by **Villeroy** » Sat May 21, 2011 8:23 pm

Double-click the chart.
DOuble-click the x-axis.
Set the minumum and maximum to "automatic", so it adjusts to the minum and maximum of the actual data.

dsosterman · Post by **dsosterman** » Sun May 22, 2011 12:31 am

Thank you very, very much. That's so simple. And it's perfect. I will post this to the original forum. And you have done your good deed for the day. David

[Solved] Date Range Help Medical Record

[Solved] Date Range Help Medical Record

Re: Date Range Help Medical Record

Re: Date Range Help Medical Record

Re: Date Range Help Medical Record

Re: Date Range Help Medical Record

Re: Date Range Help Medical Record

Re: Solved Date Range Help Medical Record