Documents for Excel, .NET Edition Documentation
Manage Data / Use Chart / Work with Chart Types
In This Topic
    Work with Chart Types
    In This Topic

    GcExcel supports a wide range of chart types such as Area, Column, Line, Pie, Bar, Combo, Stock, Surface, Scatter, Radar, Statistical and Specialized charts. It also supports new Excel 2016 statistical and specialized chart types like Sunburst, Pareto, Treemap, Histogram, WaterFall, Box and Whisker, and Funnel. The new chart types represent and analyze hierarchical data better than conventional charts.

    This topic gives a quick snapshot of all major chart types and their use cases.

    Chart Type Chart Snapshot Use Case

    Area Charts

    • Area
    • Area3D
    • AreaStacked
    • AreaStacked100
    • AreaStacked1003D
    • AreaStacked3D
    Area charts

    Area charts

    An Area chart is used to represent data that follows a time-series relationship.This type of chart is ideal when you need to show the plot change over time and depict the total value across a trend by showing the sum of the plotted values.

    Bar Charts

    • BarClustered
    • BarClustered3D
    • BarStacked
    • BarStacked100
    • BarStacked1003D
    • BarStacked3D
    Bar charts

    Bar charts

    Bar charts are used for showing patterns and trends across different categories. In these charts, each horizontal bar corresponds to a category and its length corresponds to the value or measure of that category.

    Column Charts

    • Column3D
    • ColumnClustered
    • ColumnClustered3D
    • ColumnStacked
    • ColumnStacked100
    • ColumnStacked1003D
    • ColumnStacked3D
    Column charts

    Column charts

    Unlike bar charts, Column charts use vertical columns/bars for representing data. These charts are generally used to plot data easily on X-axis.

    Combo Chart

    • Combo
    Combo charts

    Combo charts

    The combo of two or more different charts can be used in the same plot area to compare the different data sets that are related to each other.

    Line Charts

    • Line
    • Line3D
    • LineMarkers
    • LineMarkersStacked
    • LineMarkersStacked100
    • LineStacked
    • LineStacked100
    Line charts

    Line charts

    Line charts are used to plot continuously changing data against an interval of time. They can also be used to plot data against other continuous periodic values such as temperature, distance, humidity, share price, earnings per share etc.)

    Pie Charts

    • Pie
    • Pie3D
    • PieExploded
    • PieExploded3D
    • PieOfPie
    • BarOfPie
    • Doughnut
    • DoughnutExploded
    Pie charts

    Pie charts

    Pie charts are used to represent the relative contribution of various categories.It is one of the most commonly used charts and makes it easy to compare proportions by displaying the contribution of each value (slice) to a total (pie).

    Stock Charts

    • StockHLC
    • StockOHLC
    • StockVHLC
    • StockVOHLC
    Stock charts

    Stock charts

    A Stock chart is used to illustrate fluctuations in data. It can represent fluctuations for stock, daily rainfall, or annual temperatures. Typically, this chart is ideal for analyzing financial data and visualizing stock information.

    Surface Charts

    • Surface
    • SurfaceTopView
    • SurfaceTopViewWireframe
    • SurfaceWireframe
    Surface charts

    Surface charts

    Surface charts are used to find the optimum combinations between two sets of data. As in a topographic map, the colors and patterns indicate the areas that are in the same range of values.

    XY (Scatter) Charts

    • XYScatter
    • XYScatterLines
    • XYScatterLinesNoMarkers
    • XYScatterSmooth
    • XYScatterSmoothNoMarkers
    • Bubble
    • Bubble3DEffect
    Scatter charts

    Scatter charts

    An XY chart (also called scatter diagram) is a two-dimensional chart that shows the relationship between two variables. In a scatter graph, both horizontal and vertical axes are value axes that plot numeric data to show the correlation between two variables.

    Radar Charts

    • Radar
    • Radar Filled
    • Radar Markers
    Radar charts

    Radar charts

    Radar charts are radial charts that help in visualizing comparison of two or more groups of values against various features or characteristics. These charts represent each variable on a separate axis, which are arranged radially at equal distances from each other.

    Statistical Charts

    • Box and Whisker
    • Histogram
    • Waterfall
    • Pareto
    Statistical charts

    Statistical charts

    Statistical charts help summarize and add visual meaning to key characteristics of data, including range, distribution, mean and median. It can also be used to in present and interpret statistical data in graphical format.

    Specialized Charts

    • Sunburst
    • Treemap
    • Funnel
    Specialized charts

    Specialized charts

    Specialized chart types provided by GcExcel have unique data representation to show hierarchies and relationships. Such visual comparisons allow users to analyze the data thoroughly.