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

Aqua Data Studio 7.5 has an enhanced Charting Toolkit. The following new Chart Types are introduced in this version: Clustered Column Chart - Clustered column charts compare values across categories. The columns are grouped together. Stacked Column Chart - A column chart in which multiple series are placed vertically.  Stacked column charts display the relationship of individual portions to the whole, comparing the contribution of each value to a total across categories. Clustered Bar Chart - Clustered bar charts compare values across categories. Categories are usually presented along the vertical axis, and values on the horizontal axis. Wikipedia article on Bar Charts http://en.wikipedia.org/wiki/Bar-chart Stacked Bar Chart - A bar chart where multiple series are stacked vertically. Stacked bar charts show the relationship of individual items to the whole. Stacked Line Chart - Sometimes displayed with markers to hightlight individual data values, stacked line charts  show the trend of the contribution of each value over time. Scatter Plot Chart - You can now display values for two variables for a set of data as a collection of points. This enhancement in ADS 7.5 displays each point, having the value of one variable determining the position on the horizontal axis and the value of the other variable determining the position on the vertical axis. Wikipedia article on Scatter Plots http://en.wikipedia.org/wiki/Scatterplot Bubble Chart - A bubble chart displays a set of numeric values as a circles. It is especially useful when the values differ by several orders of magnitude. ADS 7.5 displays data values that differ by a ratio of 100,000 and can display hundreds of individual values at once. Open-High-Low-Close chart - Stock market users will find this type of chart useful to depict prices with a open-high-low-close chart. This takes a 3 data series (High, Low, Close). Wikipedia article on High-Low-Close Chart http://en.wikipedia.org/wiki/Open-high-low-close_chart Candlestick Chart - You can now use a variation of bar chart to describe price movements of an equity over time. This type of chart plots a 5 series data (Open, Close, Low, High and a relative plot to the prior periods' prices). Wikipedia article on Candlestick Charts http://en.wikipedia.org/wiki/Candlestick_chart

    => Enhanced Charts
        -> Support Cone/Cylinder/Pyramid on Bar charts
        -> Support Cone/Cylinder/Pyramid on Stacked & Stacked Bar charts
        -> Reverse Cones & Pyramids for Negative numbers for Column / Bar
        -> HLC, Candlestick, Bubble: range is based on Stacked chart's assumptions
        -> [x] Cylinder, [x] Cone, & [x] Pyramid versions of all Column & Bar charts
        -> Pie pieces now in counter-clockwise order
        -> Exploded Pie option
        -> Lines connecting pie chart to pie label
        -> Pie Option to indicate distance from label to pie slice
        -> Multi-selecting categories in Result Chart should behave like Pivot Table (concatenate)
        -> Numeric Category Range / Date-Time Category Range (1-1000, Oct 1 - Nov 1, 5:00am - 6:00pm)

    => Chart Function Series (Std dev, etc)
        -> Support adding function series to model
        -> Power/Exponent
        -> Linear Regression
        -> Logarithmic
        -> Moving Average w/ Period variable (period = 2 to 4)
        -> Add/Subtract
        -> Scalar
        -> give functions default parameters when created in ChartOptionDialog
        -> Add slope & intercept along the linear regression line (add interface to display it per charttype)

    => Chart Options
        -> ChartOptionDialog: Save Options as Default
        -> Add "Reset"    button
        -> ChartOptionDialog: Add/Remove Series Functions
        -> Don't remove model columns (only functions)
        -> Set name to show function name & parameters
        -> Options to Hide/Show All Axis Labels

    => Export to Excel Support
        -> 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?
        -> HighLowCLose => export order: High, Low, Close
        -> Candlestick - export order: Open, High, Low, Close
        -> Bubble - export order: [Position], [Position, Size]
        -> Stacked Bar/Line/Cone/Cylinder/Pyramid
        -> Clustered Bar/Column (cube, cone, cylinder, pyramid)