To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=60010
------- Additional comments from [EMAIL PROTECTED] Wed Jan 4 12:39:48 -0800 2006 ------- OK I will try. I think it will help if I explain the purpose of the spreadsheet first. I hope to design the spreadsheet to help diabetic people to manage their diabetes easier. The first sheet is for data entry. It is simply a running commentary on how much insulin and of what type and when, and the readings obtained with a glucometer and when. The second sheet PARAMETERS is a parameter input so that a range of dates can be looked at in detail. The third sheet REPORTS DATA dynamically selects from the first sheet only the time slice that is selected on the parameter sheet. The fourth sheet PIE CHART analyzes the dyamic data on the REPORTS DATA sheet and displays how tightly the blood sugar has been controlled during the selected dates. These charts dynamically change as the control data changes. The fifth sheet, DAILY GLUCOSE SPREAD is designed to provide visually how the glucose varies with time, and provide trends so that insulin adjustments can be made when needed. This chart is an X-Y graph and is the one that I have not been able to get to dynamically adjust as the time slices are changed. What I want is for the X-Axis to always adjust to the dates on the REPORTS DATA sheet, cell AQ3 to AQ? (however far the dates go down the AQ column). This is the problem I am trying to crack. Even if I could tell the X-axis to begin with cell D3 and end with cell E3 on the DAILY GLUCOSE SPREAD sheet that would do it. Please get back to me if you need more information about any of this. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
