EasyXLS

Chart.bas

Attribute VB_Name = "Chart"
Public CHART_CHART_TYPE_COLUMN_CLUSTERED As Long
Public CHART_CHART_TYPE_COLUMN_STACKED As Long
Public CHART_CHART_TYPE_COLUMN_100_PERCENT_STACKED As Long
Public CHART_CHART_TYPE_COLUMN_3D_CLUSTERED As Long
Public CHART_CHART_TYPE_COLUMN_3D_STACKED As Long
Public CHART_CHART_TYPE_COLUMN_3D_100_PERCENT_STACKED As Long
Public CHART_CHART_TYPE_COLUMN_3D As Long
Public CHART_CHART_TYPE_BAR_CLUSTERED As Long
Public CHART_CHART_TYPE_BAR_STACKED As Long
Public CHART_CHART_TYPE_BAR_100_PERCENT_STACKED As Long
Public CHART_CHART_TYPE_BAR_3D_CLUSTERED As Long
Public CHART_CHART_TYPE_BAR_3D_STACKED As Long
Public CHART_CHART_TYPE_BAR_3D_100_PERCENT_STACKED As Long
Public CHART_CHART_TYPE_LINE As Long
Public CHART_CHART_TYPE_LINE_STACKED As Long
Public CHART_CHART_TYPE_LINE_100_PERCENT_STACKED As Long
Public CHART_CHART_TYPE_LINE_MARKERS As Long
Public CHART_CHART_TYPE_LINE_STACKED_MARKERS As Long
Public CHART_CHART_TYPE_LINE_100_PERCENT_STACKED_MARKERS As Long
Public CHART_CHART_TYPE_LINE_3D As Long
Public CHART_CHART_TYPE_PIE As Long
Public CHART_CHART_TYPE_PIE_3D As Long
Public CHART_CHART_TYPE_PIE_OF_PIE As Long
Public CHART_CHART_TYPE_PIE_EXPLODED As Long
Public CHART_CHART_TYPE_PIE_3D_EXPLODED As Long
Public CHART_CHART_TYPE_BAR_OF_PIE As Long
Public CHART_CHART_TYPE_SCATTER As Long
Public CHART_CHART_TYPE_SCATTER_SMOOTHED_LINES_MARKERS As Long
Public CHART_CHART_TYPE_SCATTER_SMOOTHED_LINES As Long
Public CHART_CHART_TYPE_SCATTER_LINES_MARKERS As Long
Public CHART_CHART_TYPE_SCATTER_LINES As Long
Public CHART_CHART_TYPE_AREA As Long
Public CHART_CHART_TYPE_AREA_STACKED As Long
Public CHART_CHART_TYPE_AREA_100_PERCENT_STACKED As Long
Public CHART_CHART_TYPE_AREA_3D As Long
Public CHART_CHART_TYPE_AREA_3D_STACKED As Long
Public CHART_CHART_TYPE_AREA_3D_100_PERCENT_STACKED As Long
Public CHART_CHART_TYPE_DOUGHNUT As Long
Public CHART_CHART_TYPE_DOUGHNUT_EXPLODED As Long
Public CHART_CHART_TYPE_RADAR As Long
Public CHART_CHART_TYPE_RADAR_MARKERS As Long
Public CHART_CHART_TYPE_RADAR_FILLED As Long
Public CHART_CHART_TYPE_SURFACE_3D As Long
Public CHART_CHART_TYPE_SURFACE_3D_WIREFRAME As Long
Public CHART_CHART_TYPE_SURFACE_CONTOUR As Long
Public CHART_CHART_TYPE_SURFACE_CONTOUR_WIREFRAME As Long
Public CHART_CHART_TYPE_BUBBLE As Long
Public CHART_CHART_TYPE_BUBBLE_3D_EFFECT As Long
Public CHART_CHART_TYPE_STOCK_HIGH_LOW_CLOSE As Long
Public CHART_CHART_TYPE_STOCK_OPEN_HIGH_LOW_CLOSE As Long
Public CHART_CHART_TYPE_STOCK_VOLUME_HIGH_LOW_CLOSE As Long
Public CHART_CHART_TYPE_STOCK_VOLUME_OPEN_HIGH_LOW_CLOSE As Long
Public CHART_CHART_TYPE_CYLINDER_COLUMN As Long
Public CHART_CHART_TYPE_CYLINDER_COLUMN_STACKED As Long
Public CHART_CHART_TYPE_CYLINDER_COLUMN_100_PERCENT_STACKED As Long
Public CHART_CHART_TYPE_CYLINDER_BAR As Long
Public CHART_CHART_TYPE_CYLINDER_BAR_STACKED As Long
Public CHART_CHART_TYPE_CYLINDER_BAR_100_PERCENT_STACKED As Long
Public CHART_CHART_TYPE_CYLINDER_COLUMN_3D As Long
Public CHART_CHART_TYPE_CONE_COLUMN As Long
Public CHART_CHART_TYPE_CONE_COLUMN_STACKED As Long
Public CHART_CHART_TYPE_CONE_COLUMN_100_PERCENT_STACKED As Long
Public CHART_CHART_TYPE_CONE_BAR As Long
Public CHART_CHART_TYPE_CONE_BAR_STACKED As Long
Public CHART_CHART_TYPE_CONE_BAR_100_PERCENT_STACKED As Long
Public CHART_CHART_TYPE_CONE_COLUMN_3D As Long
Public CHART_CHART_TYPE_PYRAMID_COLUMN As Long
Public CHART_CHART_TYPE_PYRAMID_COLUMN_STACKED As Long
Public CHART_CHART_TYPE_PYRAMID_COLUMN_100_PERCENT_STACKED As Long
Public CHART_CHART_TYPE_PYRAMID_BAR As Long
Public CHART_CHART_TYPE_PYRAMID_BAR_STACKED As Long
Public CHART_CHART_TYPE_PYRAMID_BAR_100_PERCENT_STACKED As Long
Public CHART_CHART_TYPE_PYRAMID_COLUMN_3D As Long
Public CHART_LEGEND_BOTTOM As Long
Public CHART_LEGEND_CORNER As Long
Public CHART_LEGEND_TOP As Long
Public CHART_LEGEND_RIGHT As Long
Public CHART_LEGEND_LEFT As Long
Public CHART_LEGEND_NOT_DOCKED_OR_INSIDE_THE_PLOT_AREA As Long
Public CHART_KEYS_ARRANGEMENT_DIRECTION_HORIZONTAL As Long
Public CHART_KEYS_ARRANGEMENT_DIRECTION_VERTICAL As Long
Public CHART_LINE_STYLE_SOLID As Long
Public CHART_LINE_STYLE_DASH As Long
Public CHART_LINE_STYLE_DOT As Long
Public CHART_LINE_STYLE_DASH_DOT As Long
Public CHART_LINE_STYLE_DASH_DOT_DOT As Long
Public CHART_LINE_STYLE_NONE As Long
Public CHART_LINE_STYLE_DARK_GRAY As Long
Public CHART_LINE_STYLE_MEDIUM_GRAY As Long
Public CHART_LINE_STYLE_LIGHT_GRAY As Long
Public CHART_LINE_WEIGHT_HAIRLINE As Long
Public CHART_LINE_WEIGHT_NARROW As Long
Public CHART_LINE_WEIGHT_MEDIUM As Long
Public CHART_LINE_WEIGHT_WIDE As Long
Public CHART_LINE_WEIGHT_ZERO As Long
Public CHART_AXIS_TICK_MARK_TYPE_NONE As Long
Public CHART_AXIS_TICK_MARK_TYPE_INSIDE As Long
Public CHART_AXIS_TICK_MARK_TYPE_OUTSIDE As Long
Public CHART_AXIS_TICK_MARK_TYPE_CROSS As Long
Public CHART_AXIS_TICK_MARK_LABEL_NONE As Long
Public CHART_AXIS_TICK_MARK_LABEL_LOW As Long
Public CHART_AXIS_TICK_MARK_LABEL_HIGH As Long
Public CHART_AXIS_TICK_MARK_LABEL_NEXT_TO_AXIS As Long
Public CHART_SERIES_DATA_LABELS_NONE As Long
Public CHART_SERIES_DATA_LABELS_SHOW_VALUE As Long
Public CHART_SERIES_DATA_LABELS_SHOW_PERCENT As Long
Public CHART_SERIES_DATA_LABELS_SHOW_LABEL As Long
Public CHART_SERIES_DATA_LABELS_SHOW_LABEL_AND_PERCENT As Long
Public CHART_SERIES_DATA_LABELS_SHOW_BUBBLE_SIZE As Long
Public CHART_SERIES_IN_ROWS As Long
Public CHART_SERIES_IN_COLUMNS As Long
Public CHART_SERIES_MARKER_AUTOMATIC As Long
Public CHART_SERIES_MARKER_NONE As Long
Public CHART_SERIES_MARKER_SQUARE As Long
Public CHART_SERIES_MARKER_DIAMOND As Long
Public CHART_SERIES_MARKER_TRIANGLE As Long
Public CHART_SERIES_MARKER_X As Long
Public CHART_SERIES_MARKER_STAR As Long
Public CHART_SERIES_MARKER_DOW_JONES As Long
Public CHART_SERIES_MARKER_STANDARD_DEVIATION As Long
Public CHART_SERIES_MARKER_CIRCLE As Long
Public CHART_SERIES_MARKER_PLUS_SIGN As Long
Public CHART_SPLIT_BY_POSITION As Long
Public CHART_SPLIT_BY_VALUE As Long
Public CHART_SPLIT_BY_PERCENTAGE_VALUE As Long
Public CHART_BUBBLE_SIZE_REPRESENTS_AREA_OF_BUBBLES As Long
Public CHART_BUBBLE_SIZE_REPRESENTS_WIDTH_OF_BUBBLES As Long

Sub Initialize()
    CHART_CHART_TYPE_COLUMN_CLUSTERED = 0
    CHART_CHART_TYPE_COLUMN_STACKED = 1
    CHART_CHART_TYPE_COLUMN_100_PERCENT_STACKED = 2
    CHART_CHART_TYPE_COLUMN_3D_CLUSTERED = 3
    CHART_CHART_TYPE_COLUMN_3D_STACKED = 4
    CHART_CHART_TYPE_COLUMN_3D_100_PERCENT_STACKED = 5
    CHART_CHART_TYPE_COLUMN_3D = 6
    CHART_CHART_TYPE_BAR_CLUSTERED = 10
    CHART_CHART_TYPE_BAR_STACKED = 11
    CHART_CHART_TYPE_BAR_100_PERCENT_STACKED = 12
    CHART_CHART_TYPE_BAR_3D_CLUSTERED = 13
    CHART_CHART_TYPE_BAR_3D_STACKED = 14
    CHART_CHART_TYPE_BAR_3D_100_PERCENT_STACKED = 15
    CHART_CHART_TYPE_LINE = 20
    CHART_CHART_TYPE_LINE_STACKED = 21
    CHART_CHART_TYPE_LINE_100_PERCENT_STACKED = 22
    CHART_CHART_TYPE_LINE_MARKERS = 23
    CHART_CHART_TYPE_LINE_STACKED_MARKERS = 24
    CHART_CHART_TYPE_LINE_100_PERCENT_STACKED_MARKERS = 25
    CHART_CHART_TYPE_LINE_3D = 26
    CHART_CHART_TYPE_PIE = 30
    CHART_CHART_TYPE_PIE_3D = 31
    CHART_CHART_TYPE_PIE_OF_PIE = 32
    CHART_CHART_TYPE_PIE_EXPLODED = 33
    CHART_CHART_TYPE_PIE_3D_EXPLODED = 34
    CHART_CHART_TYPE_BAR_OF_PIE = 35
    CHART_CHART_TYPE_SCATTER = 40
    CHART_CHART_TYPE_SCATTER_SMOOTHED_LINES_MARKERS = 41
    CHART_CHART_TYPE_SCATTER_SMOOTHED_LINES = 42
    CHART_CHART_TYPE_SCATTER_LINES_MARKERS = 43
    CHART_CHART_TYPE_SCATTER_LINES = 44
    CHART_CHART_TYPE_AREA = 50
    CHART_CHART_TYPE_AREA_STACKED = 51
    CHART_CHART_TYPE_AREA_100_PERCENT_STACKED = 52
    CHART_CHART_TYPE_AREA_3D = 53
    CHART_CHART_TYPE_AREA_3D_STACKED = 54
    CHART_CHART_TYPE_AREA_3D_100_PERCENT_STACKED = 55
    CHART_CHART_TYPE_DOUGHNUT = 60
    CHART_CHART_TYPE_DOUGHNUT_EXPLODED = 61
    CHART_CHART_TYPE_RADAR = 70
    CHART_CHART_TYPE_RADAR_MARKERS = 71
    CHART_CHART_TYPE_RADAR_FILLED = 72
    CHART_CHART_TYPE_SURFACE_3D = 80
    CHART_CHART_TYPE_SURFACE_3D_WIREFRAME = 81
    CHART_CHART_TYPE_SURFACE_CONTOUR = 82
    CHART_CHART_TYPE_SURFACE_CONTOUR_WIREFRAME = 83
    CHART_CHART_TYPE_BUBBLE = 90
    CHART_CHART_TYPE_BUBBLE_3D_EFFECT = 91
    CHART_CHART_TYPE_STOCK_HIGH_LOW_CLOSE = 100
    CHART_CHART_TYPE_STOCK_OPEN_HIGH_LOW_CLOSE = 101
    CHART_CHART_TYPE_STOCK_VOLUME_HIGH_LOW_CLOSE = 102
    CHART_CHART_TYPE_STOCK_VOLUME_OPEN_HIGH_LOW_CLOSE = 103
    CHART_CHART_TYPE_CYLINDER_COLUMN = 110
    CHART_CHART_TYPE_CYLINDER_COLUMN_STACKED = 111
    CHART_CHART_TYPE_CYLINDER_COLUMN_100_PERCENT_STACKED = 112
    CHART_CHART_TYPE_CYLINDER_BAR = 113
    CHART_CHART_TYPE_CYLINDER_BAR_STACKED = 114
    CHART_CHART_TYPE_CYLINDER_BAR_100_PERCENT_STACKED = 115
    CHART_CHART_TYPE_CYLINDER_COLUMN_3D = 116
    CHART_CHART_TYPE_CONE_COLUMN = 120
    CHART_CHART_TYPE_CONE_COLUMN_STACKED = 121
    CHART_CHART_TYPE_CONE_COLUMN_100_PERCENT_STACKED = 122
    CHART_CHART_TYPE_CONE_BAR = 123
    CHART_CHART_TYPE_CONE_BAR_STACKED = 124
    CHART_CHART_TYPE_CONE_BAR_100_PERCENT_STACKED = 125
    CHART_CHART_TYPE_CONE_COLUMN_3D = 126
    CHART_CHART_TYPE_PYRAMID_COLUMN = 130
    CHART_CHART_TYPE_PYRAMID_COLUMN_STACKED = 131
    CHART_CHART_TYPE_PYRAMID_COLUMN_100_PERCENT_STACKED = 132
    CHART_CHART_TYPE_PYRAMID_BAR = 133
    CHART_CHART_TYPE_PYRAMID_BAR_STACKED = 134
    CHART_CHART_TYPE_PYRAMID_BAR_100_PERCENT_STACKED = 135
    CHART_CHART_TYPE_PYRAMID_COLUMN_3D = 136
    CHART_LEGEND_BOTTOM = 0
    CHART_LEGEND_CORNER = 1
    CHART_LEGEND_TOP = 2
    CHART_LEGEND_RIGHT = 3
    CHART_LEGEND_LEFT = 4
    CHART_LEGEND_NOT_DOCKED_OR_INSIDE_THE_PLOT_AREA = 7
    CHART_KEYS_ARRANGEMENT_DIRECTION_HORIZONTAL = 0
    CHART_KEYS_ARRANGEMENT_DIRECTION_VERTICAL = 1
    CHART_LINE_STYLE_SOLID = 0
    CHART_LINE_STYLE_DASH = 1
    CHART_LINE_STYLE_DOT = 2
    CHART_LINE_STYLE_DASH_DOT = 3
    CHART_LINE_STYLE_DASH_DOT_DOT = 4
    CHART_LINE_STYLE_NONE = 5
    CHART_LINE_STYLE_DARK_GRAY = 6
    CHART_LINE_STYLE_MEDIUM_GRAY = 7
    CHART_LINE_STYLE_LIGHT_GRAY = 8
    CHART_LINE_WEIGHT_HAIRLINE = -1
    CHART_LINE_WEIGHT_NARROW = 0
    CHART_LINE_WEIGHT_MEDIUM = 1
    CHART_LINE_WEIGHT_WIDE = 2
    CHART_LINE_WEIGHT_ZERO = 65535
    CHART_AXIS_TICK_MARK_TYPE_NONE = 0
    CHART_AXIS_TICK_MARK_TYPE_INSIDE = 1
    CHART_AXIS_TICK_MARK_TYPE_OUTSIDE = 2
    CHART_AXIS_TICK_MARK_TYPE_CROSS = 3
    CHART_AXIS_TICK_MARK_LABEL_NONE = 0
    CHART_AXIS_TICK_MARK_LABEL_LOW = 1
    CHART_AXIS_TICK_MARK_LABEL_HIGH = 2
    CHART_AXIS_TICK_MARK_LABEL_NEXT_TO_AXIS = 3
    CHART_SERIES_DATA_LABELS_NONE = 0
    CHART_SERIES_DATA_LABELS_SHOW_VALUE = 1
    CHART_SERIES_DATA_LABELS_SHOW_PERCENT = 2
    CHART_SERIES_DATA_LABELS_SHOW_LABEL = 3
    CHART_SERIES_DATA_LABELS_SHOW_LABEL_AND_PERCENT = 4
    CHART_SERIES_DATA_LABELS_SHOW_BUBBLE_SIZE = 5
    CHART_SERIES_IN_ROWS = 0
    CHART_SERIES_IN_COLUMNS = 1
    CHART_SERIES_MARKER_AUTOMATIC = -1
    CHART_SERIES_MARKER_NONE = 0
    CHART_SERIES_MARKER_SQUARE = 1
    CHART_SERIES_MARKER_DIAMOND = 2
    CHART_SERIES_MARKER_TRIANGLE = 3
    CHART_SERIES_MARKER_X = 4
    CHART_SERIES_MARKER_STAR = 5
    CHART_SERIES_MARKER_DOW_JONES = 6
    CHART_SERIES_MARKER_STANDARD_DEVIATION = 7
    CHART_SERIES_MARKER_CIRCLE = 8
    CHART_SERIES_MARKER_PLUS_SIGN = 9
    CHART_SPLIT_BY_POSITION = 0
    CHART_SPLIT_BY_VALUE = 1
    CHART_SPLIT_BY_PERCENTAGE_VALUE = 2
    CHART_BUBBLE_SIZE_REPRESENTS_AREA_OF_BUBBLES = 1
    CHART_BUBBLE_SIZE_REPRESENTS_WIDTH_OF_BUBBLES = 2
End Sub

EasyXLS Excel components:

.NET
Excel Library for VB6
full COM+ version to import, export or convert Excel files
Excel Writer for VB6
COM+ version to create and export Excel files
Excel Reader for VB6
COM+ version to read and import Excel files
Download EasyXLS™ Excel Component for VB6

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2019
MS Excel 2021
Office 365
XLSXXLSMXLSBXLS
XMLHTMLCSVTXT