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

    Creates a pie 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 SparkPie Chart Designer.

    Syntax

    XL3SparkPie( Data, Output, InRows, [Colour1], [Colour2], [Colour3], [Colour4], [Colour5], [Colour6], [Colour7], [Colour8], [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
    Colour1 The colour for the first sector, or -1 or an empty parameter for default
    Colour2 The colour for the second sector, or -1 or an empty parameter for default
    Colour3 The colour for the third sector, or -1 or an empty parameter for default
    Colour4 The colour for the fourth sector, or -1 or an empty parameter for default
    Colour5 The colour for the fifth sector, or -1 or an empty parameter for default
    Colour6 The colour for the sixth sector, or -1 or an empty parameter for default
    Colour7 The colour for the seventh sector, or -1 or an empty parameter for default
    Colour8 The colour for the eighth sector, or -1 or an empty parameter for default
    Label Specifies the text to use in the formula cell

    See Also