To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74204 Issue #|74204 Summary|Smart charts Component|Spreadsheet Version|OOo 2.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|dbadams
------- Additional comments from [EMAIL PROTECTED] Tue Feb 6 02:20:29 +0000 2007 ------- Problem: Need dynamic charting for ongoing KPI maintenance. On a weekly basis we have KPI's that are updated into Excel. Data is charted with prior 4 weeks (prior month), plus current 4 weeks (current month). In Excel, each data range has to be manually changed in each chart each week. Requested feature additions: 1. Have a check box to surpress blank data points. Example: Create a chart with data from rows 1 to 30 for days of the month. On day 1 you have data, but the chart shows all 30 data points with blanks or -0-. When check box is checked, Any data points that are blank, are not graphed. 2. Have check box to select rolling average, and field for entering number of recent data points to graph. In example above, with rolling average checked, and graph points set to 5, the chart would graph data points 1-5. When data is entered for data point 6, the chart graphs points 2-6. --------------------------------------------------------------------- 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]
