Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • XL3SparkBar

    Creates a bar chart that is rendered in an Excel cell.

    Double-clicking the chart, or selecting the XLCubed > Format In-Cell Chart... right-click menu item allow the editing of the chart format using the SparkBar Chart Designer.

    Syntax

    XL3SparkBar( Data, Output, InRows, [LongestBarLength], [Colour1], [Colour2], [Colour3], [Colour4], [Colour5], [Colour6], [Colour7], [Colour8], [IsStacked100%], [ShowZeros], [Minimum], [Maximum], [DataLabelAlign], [DataLabelFontName], [DataLabelFontSize], [DataLabelFormatString], [DataLabelFontStyle], [DataLabelColour], [AxisType], [MajorTickmarkFrequency], [MinorTickmarksPerMajor], [TickmarkLabelFormatString], [Label] )

    Parameters

    Parameter Description
    Data The data to chart. This can be a range or a formula
    Output The target range in which to render the chart(s)
    InRows Specifies whether the input data are in rows or columns:
    0 Data are in rows
    1 Data are in columns
    LongestBarLength The length of the longest bar (in characters)
    Colour1 The colour for the bar chart, or the first section in a stacked bar, or -1 or an empty parameter for default
    Colour2 The colour for the second section, or -1 or an empty parameter for default
    Colour3 The colour for the third section, or -1 or an empty parameter for default
    Colour4 The colour for the fourth section, or -1 or an empty parameter for default
    Colour5 The colour for the fifth section, or -1 or an empty parameter for default. Negative bar colours start from here
    Colour6 The colour for the sixth section, or -1 or an empty parameter for default
    Colour7 The colour for the seventh section, or -1 or an empty parameter for default
    Colour8 The colour for the eighth section, or -1 or an empty parameter for default
    IsStacked100% For bars with multiple data points, defines whether the bar length should be the same for all charts, or whether the bar length should be proportional to the total for that bar:
    0 Total bar width varies according to the total, with the longest bar width given by the LongestBarLength parameter
    1 Bar widths are all equal, with the widths of individual data points showing their proportion of the total
    ShowZeros Specifies whether to draw bars for zero-valued data points
    Minimum A value to use for the minimum horizontal axis value, or an empty parameter to use an automatic value
    Maximum A value to use for the maximum horizontal axis value, or an empty parameter to use an automatic value
    DataLabelAlign Specifies the position of data labels for the bars:
    0 No data label
    1 Draw labels after the bars
    2 Draw labels before the bars
    DataLabelFontName The typeface to use for the data labels
    DataLabelFontSize The font size for the data labels
    DataLabelFormatString The format string for the data labels
    DataLabelFontStyle Reserved.
    DataLabelColour The colour for the data labels, or -1 or an empty parameter for none
    AxisType The type of axis to render in the formula cell:
    0 No axis
    1 Draws the axis at the top of the cell, with tickmarks below
    2 Draws the axis at the bottom of the cell, with tickmarks above
    3 Draws the axis at the top of the cell, with tickmarks and labels below
    4 Draws the axis at the bottom of the cell, with tickmarks and labels above
    MajorTickmarkFrequency The frequency of the major, labelled tickmarks
    MinorTickmarksPerMajor The number of additional labelless tickmarks per major tickmark
    TickmarkLabelFormatString The format string for the axis tickmark labels
    Label Specifies the text to use in the formula cell, if no axis is used

    See Also