Ideas and Feature Wishes for the new Chart

Core

• Titles for all axes
• Chart type percentage: allow negative values (group positive and negative values)
• Net chart: allow negative values
• Spline for area charts
• Spline on/off for single series
• Custom increment for logarithmic axis
• Draw/interpolate empty cells
• Mark interpolated points (e.g. of missing data values) with different color
• Pie/donut chart: correct orientation of data series/data points (clockwise)
• Anti-aliasing!
• Offer option to disconnect / connect / reconnect external data from / to a chart. E.g. copy a chart via clipboard from Calc to Draw. The chart inside the draw still gets the data from the Calc document. But it should be possible to disconnect the data, so that the chart has its own data.
• Pie chart: Set different radius for different pie segments
• Set source data for each separate series, in XY-charts each series can have its own X-value range and Y-value range, set default values for X (e.g. 1, 2, 3, ...), if missing
• Set source data for series titles (e.g. for legend). These source ranges could consist of several cells, concatenate their content (optional with/without space)
• Each source data range can be a range list
• Line/XY charts: Draw every 2^nd/3^rd/... point symbol only
• Y-axis (and X-axis in XY charts): Scale axis month-wise (e.g. every 15^th of a month)
• For calculated curves like regression curves or trend lines it should be possible to display their parameters (or formulas) in the legend.
• New chart types: bubble, surface
• Set fixed data as source for series, like '={1, 2, 3, 5}'
• Set axis properties like minimum and maximum from cells of a spreadsheet
• Allow change of spacing between axis and axis labels
• grid-areas in addition to grid-lines: like in a spreadsheet, where you have an alternating background color for odd and even rows. Open question: How do you combine vertical and horizontal stripes, e.g., checked rectangles or combining the grid-colors
• Make it possible to plot error-bars for x-values as well as y-values. Allow errors for error bars to come from a data source, e.g., a column or row of a spreadsheet.
• Allow axis to go from right to left or top to bottom instead of the other way round (like usual)
• New chart-type: multiple pies in one chart. If you have a rectangular range of data you can visualize these as rings, but instead you can also put multiple complete pie-diagrams in a grid.
• If an x-axis shows categories and you have too many of them, the labels may be reduced, so that you see only some of them (such that they don't overlap). This should also affect the tick-marks. Maybe a user should also be able to enter a number (n) such that only every n^th tick-mark is drawn.
• Regression curves should also allow extrapolation (trend-lines), i.e., if the input data goes from 1.0 to 8.0, but the x-axis scale goes from 0.0 to 20.0, you should see a linear regression in the entire range from 0.0 to 20.0
• Regression curves for x-values in addition to the existing regression curves for y-values.
• It should be possible to add multiple regression curves to one data series.
• Average value line not only for y-values but also for x-values, and in addition a symbol marking the intersection point (the center of gravity).
• Formatting of single line-segments in a line- or scatter chart. (Probably by changing data-point line-style for the point to which the segment leads?)

API

• Set/get diagram area position/size with and without axis caption/data caption
• One class for all axes [ no more (X|Y|Z)AxisSupplier, only AxisSupplier ]
• New property LegendPositionManual
• Properties for legend orientation: horizontal/vertical, multiple rows/columns
• Allow access to single series of data rather than the entire array.
• Customizable axis labels. Set label texts and numbers independently from the underlying scale or categories array.

GUI

• Pie chart: change properties for all data points together
• Sizeable legend
• Data point symbol: change line and fill color
• 3d controller for rotation, Reset button
• Set dimensions for diagram size
• Apply vector graphics to chart as skin
• Flexible selection, intuitive navigation through objects
• Percentage data labels with flexible decimal places (less than two)
• Rotatable data labels
• Animation for chart elements
• Fully formatable legend
• New Data Editor
• Data Import from several data sources (Internet, Calc, Excel etc.)
• Created Chart as template on other charts assign.
• Easy to Use AutoPilot
• Provide Styles (Templates) like in other applications (or better ;-)
• Enable selection with Tab-key through all chart elements
• Format of series: make it possible to choose one, several or all series in the dialog
• Reorder all series depending on the value of a specific point of each series – Useful for e.g. stacked/percentage/donut charts
• Axis scaling dialog: Axis has time format and main/help interval is <24 hours: show them with time format instead of double
• connectors between data points and labels (especially for pies)
• allow free positioning of data labels
• dragging of pie segments should also work for donuts: change distance between rings, and allow exploding for the outermost ring.
• Allow text attributes for single portions of text (see Issuezilla task #1489)

Embedding in Spreadsheet

• Smart detection of labels. If data for a chart is structured like this:

          |   A    B    C    D
        --+--------------------
        1 |        X    Y    Z
        2 | 1999  123  234  345
        3 | 2000  876  765  654
        4 | 2001  665  443  221

  detect the numbers in the first column as labels because the cell A1 is empty
• if a column or row (especially the first one of a range) is formatted with a Heading style use it for labels

Miscellaneous

• Killer feature: net chart with spline :-)

Note: green entries are new since the last revision, blue entries are changed in the last revision