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

    Creates a column 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 SparkColumns Chart Designer.

    Syntax

    XL3SparkColumns( Data, Output, InRows, [ColumnColour], [NegativeColumnColour], [ColumnWidth], [PeriodLength], [PeriodColour], [NegativePeriodColour], [StartColour], [EndColour], [MinColour], [MaxColour], [ReferenceValues], [ReferenceColour], [Minimum], [Maximum], [UseCommonScale], [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
    ColumnColour The default colour to use for the columns
    NegativeColumnColour The default colour to use for negative columns
    ColumnWidth The width of each column
    PeriodLength The length of the period for alternate column shading
    PeriodColour The colour of the alternately coloured columns
    PeriodColour The colour of negative alternately coloured columns
    StartColour The colour to highlight the first column, or -1 or an empty parameter for none
    EndColour The colour to highlight the last column, or -1 or an empty parameter for none
    MinColour The colour to highlight the lowest column, or -1 or an empty parameter for none
    MaxColour The colour to highlight the highest column, or -1 or an empty parameter for none
    ReferenceValues A value or range to use for a reference line. To use the mean value instead, use "Average"
    ReferenceColour The colour to use for the reference line, or -1 or an empty parameter for none
    Minimum A value to use for the minimum vertical axis value, or an empty parameter to use an automatic value
    Maximum A value to use for the maximum vertical axis value, or an empty parameter to use an automatic value
    UseCommonScale Use 1 here to force all charts to use a common scale
    Label Specifies the text to use in the formula cell

    See Also