To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52845 Issue #:|52845 Summary:|Calc --> Chart versus Chart --> Calc Component:|Chart Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|TASK Priority:|P4 Subcomponent:|ui Assigned to:|kla Reported by:|servdat
------- Additional comments from [EMAIL PROTECTED] Wed Aug 3 11:43:59 -0700 2005 ------- I am trying to solve a simple issue with Excel, Lotus 1-2-3 and Calc since years and see no chance to do so as Microshit invented charts linked to spreadsheets coming (as usual) from the wrong side and by setting the industry standard dragging all competitors into the same dead end street. (What angers me most is the fact that in the times of an IBM 360 or S/3 in the 60ies and 70ies the way to handle this was there - easy and clear.) Try the following simple scenario: You are running/biking or move in whatever way irregularly on a training course and note the total time. You enter the date and running time in a Calc row using one spread sheet page within one year or season. (If you only use minutes and seconds you will encounter in Calc some completely unnecessary mistakes and inconveniences because MS didn't separate functionality and user interface; I reported this issue to OO some time ago but you cannot correct it because you have to remain compatible with MS) Now you want to create a chart and chose an xy-type and lines with symbols. The time is on the y-axis, the x-axis is defined by the date differences of the running dates (in days; can easily be calculated in additional columns). How can you now correct or adjust the following flaws: - on the x-axis you do not want a grid with days but for every entry the date printed, (although the axis is based on a column in your Calc sheet). If printing space is a problem you would need a mark on the base line of the x- axis with a number or color to link to a legend below. Eventually you would like to have a vertical line up to the time point for every date. - you might like to define the minimum, maximum and interval of either grid yourself. How can you in the course of time expand, enhance and correct your chart or combine it with other charts that have the same axis definitions and at least similar grid values without every time recreating it? (e.g. combine different seasons or compare to a friend that does the same training) etc, etc Imagine you would start with calling a chart program, where all these details mentioned can be defined at your will and in the last steps or in any additional ones later you define for each axis, and line (in this case) the underlaying Calc row or column or single value. Wouldn't that be flexible and easy to handle. Wouldn't that open all possibilities of imaginable combinations without the nightmare of recreating everything everytime from scratch? Wouldn't that allow to define some charts as templates (like the ones you supply now) with the specific scales for your purposes and in the last step define the Calc values. Or just reuse an existing chart exchanging the Calc values. The most flexible part of a chart is the values it shows; the way these charts are built now (and the mess it creates in practical life) is as if a cook would cook the meal before chosing the pan! With best regards Bruno Naumann --------------------------------------------------------------------- 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]
