Charts Toolkit for Grids & Pivot Grids  (Revision #4)

Chart Refactor
AquaCharts
Scatter Plot
AquaLogs Sorting & Pagination fix

    [x] Use ChartDataModel instead of ResultsetChartTableModel
    [x] [x] Cylinder, [x] Cone, & [x] Pyramid versions of all Column & Bar charts
    [x] Bubble - plots two data series as one chart (series 1 is the y-axis value, series 2 is the size of the bubble)
    [x[ High-Low-Close - takes 3 data series (hi, low, close)
    [x] Candlestick - plots 4 data series as one chart (http://en.wikipedia.org/wiki/Candlestick_chart)

[x] 2147    Have a right click on the top left area of the Grid Results select all, and popup the menu if possible
    What we can probably do is have the popup menu appear when you right click
    on the top left empty box, so when you right click on the top left if will
    both select all and give you the menu item for viewing in excel.
[x] DataSelectionListener problem if getChart() returns null
    ResultChartPanel.java Line 333
    Disable JOGL by taking away libraries & it reveals problem
[x] Chart Functions (Std dev, etc)
    [x] Support adding function series to model
    [x] Power/Exponent
    [x] Linear Regression
    [x] Logarithmic
    [x] Moving Average w/ Period variable (period = 2 to 4)
    [x] Add/Subtract
    [x] Scalar

[x] ADS7.0    Chart Types not being remembered after re-exec
[x] ChartOptionDialog: Add/Remove Series Functions
    [x] Don't remove model columns (only functions)
    [x] Set name to show function name & parameters
[x] Linear Regression
[x] Line chart - first point at wrong position
[x] Setting High/Low/Open/Close in candlestick properties not working (due to the foundHigh/etc logic)
[x] Fix: Line Width in option dialog not taking effect

[x] AMS: charts crashing @ AxisRenderer.java:424 and Legend.java:311
[x] ChartOptionDialog: Save Options as Default
    [x] Place buttons in toolbar
    [x] Add "Reset"    button

[x] Pie pieces now in counter-clockwise order
[x] New Charts (First Batch)
    [x] Exploded Pie option
    [x] 100% Stacked Column (see ChartProperties._hundredPercentMode)
    [x] 100% Stacked Area
    [x] Stacked Line (with & without markers at data point)
    [x] 100% Stacked Line
    [x] Stacked Bar
    [x] 100% Stacked Bar
    [x] Support Cone/Cylinder/Pyramid on Bar charts
    [x] Support Cone/Cylinder/Pyramid on Stacked & Stacked Bar charts
    [x] Reverse Cones & Pyramids for Negative numbers for Column / Bar
    [x] HLC, Candlestick, Bubble: range is based on Stacked chart's assumptions
[x] Options to Hide/Show All Axis Labels
[x] Select * from orders => ETLGrid.getRows() line 47 => NPE

[x] 2205    Charts -- Series Name in Advanced Options gets replaced when I select a Function such as ADD

    MySQL 6.0 - 38 Database jonathantest  -- select * from niels_stock
    Go to Options -- Advanced Options and give a Series Name and Press OK.
     Next, take options again and Select any of the Function such as ADD, Substract , Scalar, Power etc.
    The series name will be changed when I select any of the function. See pic
[x] 2206    Charts -- After you select a Function such as add, Substract etc and If you try to enter a string in the Function Parameter, you get this error
    MySQL 6.0 - 38 Database jonathantest  -- select * from niels_stock
    Go to Options -- Advanced Options and select a Functions. Next type a string such as z in Function parameter Press OK.
    Exception occurred during event dispatching:
    java.lang.NumberFormatException: For input string: "z"
     at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
[x] Update Aspose excel export    
    [x] 66        saved in excel charts currently don’t specify column names and what kind of data is displayed
        * NOTE * Only Value Axis title is supported
        [Moved to 7.0 - Aspose has issues with displaying axis headers correctly]
        Can we output axis titles to Excel? 
    [x] HighLowCLose => export order: High, Low, Close
    [x] Candlestick - export order: Open, High, Low, Close
    [x] Bubble - export order: [Position], [Position, Size]
    [x] Stacked Bar/Line/Cone/Cylinder/Pyramid
    [x] Clustered Bar/Column (cube, cone, cylinder, pyramid)

[x] Multi-selecting categories in Result Chart should behave like Pivot Table (concatenate)

[x] Numeric Category Range / Date-Time Category Range
    1-1000, Oct 1 - Nov 1, 5:00am - 6:00pm

[x] Lines connecting pie chart to pie label

[x] give functions default parameters when created in ChartOptionDialog
[x] 2239    Caused by exporting more columns than necessary for a Multi-Series chart (Candlestick, HLC, Bubble)
[x] 2241    SQL Server 2000 -- Northwind Database. Executed the below query and then changed the option in AXES -- Use Range for category Axis
[x] ResultChartPanel: Fix Pivot Table selection (since it doesn't use Grid)
[x] 2240    If 2D view is selected then Lighting Options doest work in ADS build 7.4.19
[x] 2247    Execute the below query in SQL Server 2000 in Northwind Database.
[x] 2248    In Chart Options -- Advanced Tab once you add a function series - the Remove Function Series Icon doesnt work
[x] 2243    After issue number 2241 described in AC -- ADS gives java.lang.IndexOutOfBoundsException
[x] 2244    Maximum of Stock HIgh value in this table is 100 - When I select Candlestick Chart. it goes out of the graph axis.
[x] 2245    SQL Server 2000 -- Northwind database. Executed below query after changing the Advanced Chart Options to
[x] freight + freight on use category axis range
[x] Pivot Table => Use Category Range (freight & ShippedDate)
[x] Anything to increase size if cone/pyramid when lots of items?
    ANSWER: Adjust the global category spacing value
[CNR] 2246    Bubble Chart -- Executing queries results in Exception
[x] ADS 7.0: Losing chart types for stackedarea

[x] Add slope & intercept along the linear regression line (add interface to display it per charttype)
[x] Pie Option to indicate distance from label to pie slice
[x] Pie Labels not showing tooltip value (to see actual value instead of %)