9.3 Working with new
& Enhanced 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 |
- Candlesticks are used to show stock price
- Each candlestick shows the stock's high, low, opening and
closing prices. The wick shows the stock's high and low prices
- The body of a candlestick shows the stock's opening and closing
prices
- A day is an up day if the closing price is greater than the
opening price
- The body color is used to flag if it is an up day (GREEN) or
down day (RED)
Working with Open-high-low-close
Chart

|
| Open-high-close Chart |
- In a high-low-close plot the vertical line represents the high
and low values over one unit of time.
- The close value is represented by a "tick" to the right. The
open value, if present, is represented by a tick to the left.
- If today's close is higher than yesterday's close - the bar is
colored green/blue.
- If today's close is lower than yesterday's close - the bar is
colored red.
- If today's close is equal to yesterday's close - the bar is
colored the same as yesterday.
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.
- In a high-low-close plot the vertical line represents the high
and low values over one unit of time.
- The close value is represented by a "tick" to the right. The
open value, if present, is represented by a tick to the left.
- If today's close is higher than yesterday's close - the bar is
colored green/blue.
- If today's close is lower than yesterday's close - the bar is
colored red.
- If today's close is equal to yesterday's close - the bar is
colored the same as yesterday.
Working with Stacked Area
Charts

|
| Stacked Area Chart |
A stacked area chart is used to map multiple series over
different categories like time.
- The stacked area displays trends of each category so that the
areas are stacked, but each series does not overlap the preceding
series.
- 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.
- The scatter line chart displays points at the intersection of x
and y numerical values, making these values into single data
points.
- 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.
- 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.
- 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.
- 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".
- Scatter graphs can chart multiple data sets, each represented
by a different symbol, each having any number of data points.
|