Working with Charts

Feature Overview

•    Chart Types - Enhanced Charts include OHLC (open-high-low-close) charts, Candlestick charts, Bubble charts, Stacked charts and Scatter charts.
•    Chart Functions - Support for Functions include Addition, Subtraction, Scalar, Power, Log, Linear Regression and Moving Average.
•    Column Shape Type - Support for Cylinder, Cone & Pyramid versions of all Column & Bar charts is added  

3D High Low Close	3D Candlestick	Moving Average + Stack	New Functions

Cone	Pyramid	Cylinder	Exploded Pie

Working with Candlestick Charts

Candlestick charts can be effectively used in Aqua Data Studio 7.5 to plot data-driven charts.

Candlestick Chart

1. Candlesticks are used to show stock price. The Candlestick chart consists of three elements: the body, an upper wick and a lower wick.
2. The body is rendered as a cube, with the lower bound being the lesser of the Open and Close values, and the upper bound being the greater of the Open and Close values.  If the Close value is greater than the Open value, then the body is green.  If the Close value is less than the Open value, then the body is red.  
3. The upper wick extends from the upper bound of the body to the High value.
4. The lower wick extends from the lower bound of the body to the Low value.

Working with Open-high-low-close Chart

Open-high-close Chart

1. In a high-low-close the body is rendered as a cube, with Upper & Lower bounds being the High and Low values respectively
2. The tick mark to the right indicates the Close value

Working with Bubble Charts

Bubble Chart

A bubble chart is a two-dimensional scatterplot where a third variable is represented by the size of the points.

1. In a Bubble chart, values are represented by the position of the bubble in the horizontal and vertical axis.
2. It can be seen as a variation of the Scatter charts.

 Working with Stacked Area Charts

Stacked Area Chart

A stacked area chart is used to map multiple series over different categories like time.

1. The stacked area displays trends of each category so that the areas are stacked, but each series does not overlap the preceding series.
2. Stacked area can chart multiple data sets as an area.

Working with Scatter Line Charts

Scatter Line Chart

The scatter line chart in Aqua Data Studio 7.5 allows you to create a chart with two value axes to show one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis.

1. The scatter line chart displays points at the intersection of x and y numerical values, making these values into single data points.
2. Scatter line charts can plot numerical values like day or hour along the horizontal axis.

Working with Stacked Bar Chart

Stacked bar Chart

The Stacked Bar chart in Aqua Data Studio 7.5 allows you to create a chart displaying the results of multiple queries stacked on top of each other vertically.

1. The Stacked Bar consists of data points represented by segments of each bar, as well as total value represented by data points of each Series selected in the Chart options.
2. Each series is denoted by a different color and the entire bar is the total for the data series

Working with Scatter Charts

Scatter Chart

The scatter chart in Aqua Data Studio 7.5 allows you to create a chart showing one piece of information, such as stock value along the x-axis and another piece of information such as Company, along the y-axis. A scatter chart is used to map correlation between sets of numbers.

1. The scatter graph consists of plotted points "scattered" around an X-Y grid. The pattern may reveal a relationship between the two variables measured by the X and Y axes. In 2D scatter graphs, you can illustrate trends in the plotted points by adding a "Moving Average".
2. Scatter graphs can chart multiple data sets, each represented by a different symbol, each having any number of data points.