The Chart data region supports the following types of charts: Column, Bar, Area, Line, Pie, Scatter, Financial, and Other. See below for a description of each type as well as any sub-types offered for each.
Column Charts
Column charts present each series as a vertical column, and group the columns by category. The y-axis values determine the heights of the columns, while the x-axis displays the category labels.
Sub-types- Plain
- Use a column chart to compare values of items across categories.
- Stacked
- A stacked column chart is a column chart with two or more data series stacked one on top of the other. Use this chart to show how each value contributes to a total.
- Percent Stacked
- A percent stacked column chart is a column chart with two or more data series stacked one on top of the other to sum up to 100%. Use this chart to show how each value contributes to a total with the relative size of each series representing its contribution to the total.
Bar Charts
Bar charts present each series as a horizontal bar, and group the bars by category. The x-axis values determine the lengths of the bars, while the y-axis displays the category labels.
- Plain
- Use a bar chart to compare values of items across categories.
- Stacked
- A stacked bar chart is a bar chart with two or more data series stacked one on top of the other. Use this chart to show how each value contributes to a total.
- Percent Stacked
- A percent stacked bar chart is a bar chart with two or more data series stacked one on top of the other to sum up to 100%. Use this chart to show how each value contributes to a total with the relative size of each series representing its contribution to the total.
Area Charts
Area charts present each series as a point, connect the points with a line, and fill the area below the line. The y-axis values determine the heights of the points, while the x-axis displays the category labels.
- Plain
- Use an area chart to compare trends over a period of time or in specific categories.
- Stacked
- A stacked area chart is an area chart with two or more data series stacked one on top of the other. Use this chart to show how each value contributes to a total.
- Percent Stacked
- A percent stacked area chart is an area chart with two or more data series stacked one on top of the other to sum up to 100%. Use this chart to show how each value contributes to a total with the relative size of each series representing its contribution to the total.
Line Charts
Line charts present each series as a point, and connect the points with a line. The y-axis values determine the heights of the points, while the x-axis displays the category labels.
- Plain
- Use a line chart to compare trends over a period of time or in certain categories.
- Smooth (Bezier)
- A smooth line chart is a line chart that plots curves rather than angled lines through the data points in a series. Use a smooth line chart to compare trends over a period of time or in certain categories.
Pie Charts
Pie charts present each category as a slice of pie or doughnut, sized according to value. Series groups are not represented in pie charts.
- Pie
- Use a pie chart to show how the percentage of each data item contributes to the total.
- Exploded
- Use an exploded pie chart to show how the percentage of each data item contributes to the total, with the pie slices pulled out from the center to show detail.
- Doughnut
- A doughnut chart shows how the percentage of each data item contributes to a total percentage.
- Exploded Doughnut
- Use an exploded doughnut chart to show how the percentage of each data item contributes to the total, with slices pulled out from the doughnut to show detail.
Scatter Charts
Scatter charts present each series as a point or bubble. The y-axis values determine the heights of the points, while the x-axis displays the category labels.
- Plain
- Use a scatter chart to show the relationships between numeric values in two or more series sets of XY values.
- Connected
- A connected scatter chart plots points on the X and Y axes as one series and uses a line to connect points to each other.
- Smoothly Connected
- A smoothly connected scatter chart plots points on the X and Y axes as one series and uses a line with the angles smoothed out to connect points to each other.
- Bubble
- The Bubble chart is an XY chart in which bubbles represent data points. The first Y value is used to plot the bubble along the Y axis, and the second Y value is used to set the size of the bubble. The bubble shape can be changed using the series Shape property. Shape choices include points, squares, circles, triangles, inverted triangles, diamonds, pyramids, and crosses.
Financial Charts
Stock charts present each series as a line with markers showing some combination of high, low, open, and close values. The y-axis values determine the heights of the lines, while the x-axis displays the category labels.
- High Low Close
- A high low close chart displays stock information using High, Low, and Close values. High and low values are displayed using vertical lines, while tick marks on the right indicate closing values.
- Open High Low Close
- An open high low close chart displays stock information using Open, High, Low, and Close values. Opening values are displayed using lines to the left, while lines to the right indicate closing values. The high and low values determine the top and bottom points of the vertical lines.
- Candlestick
- A candlestick chart displays stock information using High, Low, Open and Close values. The height of the wick line is determined by the High and Low values, while the height of the bar is determined by the Open and Close values. The bar is displayed using different colors, depending on whether the price of the stock has gone up or down.
- Renko
-
The Renko chart uses bricks of uniform size to chart price movement. When a price moves to a greater or lesser value than the preset BoxSize value required to draw a new brick, a new brick is drawn in the succeeding column. The change in box color and direction signifies a trend reversal.
- Kagi
- A Kagi chart displays supply and demand trends using a sequence of linked vertical lines. The thickness and direction of the lines vary depending on the price movement. If closing prices go in the direction of the previous Kagi line, then that Kagi line is extended. However, if the closing price reverses by the preset reversal amount, a new Kagi line is charted in the next column in the opposite direction. Thin lines indicate that the price breaks the previous low (supply) while thick lines indicate that the price breaks the previous high (demand).
- Point and Figure
- The point and figure chart uses stacked columns of Xs to indicate that demand exceeds supply and columns of Os to indicate that supply exceeds demand to define pricing trends. A new X or O is added to the chart if the price moves higher or lower than the BoxSize value you set. A new column is added when the price reverses to the level of the BoxSize value multiplied by the ReversalAmount you set. The use of these values in the point and figure chart to calculate pricing trends makes this chart best suited for long-term financial analysis.
- Three Line Break
-
A three line break chart uses vertical boxes or lines to illustrate price changes of an asset or market. The price in a three line break graph must break the prior high or low set in the NewLineBreak property in order to reverse the direction of the graph.
Other Charts
Other chart types may be used for special functions like charting the progress of individual tasks.
- Funnel
- A funnel chart shows how the percentage of each data item contributes to the whole, with the largest value at the top and the smallest at the bottom. This chart type works best with relatively few data items.
- Pyramid
- A pyramid chart shows how the percentage of each data item contributes to the whole, with the smallest value at the top and the largest at the bottom. This chart type works best with relatively few data items.
- Gantt
- The Gantt chart is a project management tool used to chart the progress of individual project tasks. The chart compares project task completion to the task schedule.