Uses of Class
io.keikai.axyra.sheets.content.Chart.Builder

Packages that use Chart.Builder
Package
Description
io.keikai.axyra.sheets.content
The objects a workbook or sheet holds besides cell values: charts, tables, data validations, conditional formats, comments, hyperlinks, sparklines, form controls, slicers, timelines, external links, embedded objects and more.

  • Uses of Chart.Builder in io.keikai.axyra.sheets.content

    Methods in io.keikai.axyra.sheets.content that return Chart.Builder
    Modifier and Type
    Method
    Description
    Chart.Builder
    Chart.Builder.anchor(int fromRow, int fromColumn, int toRow, int toColumn)
    Sets the two-cell anchor (0-based).
    Chart.Builder
    Chart.Builder.anchorOffsets(int fromColOff, int fromRowOff, int toColOff, int toRowOff)
    The sub-cell EMU offsets of the two-cell anchor's from/to corners (914400 EMU = 1 inch).
    static Chart.Builder
    Chart.area()
    An area chart.
    Chart.Builder
    Chart.Builder.autoTitle(boolean on)
    Mark the chart as carrying an Excel "auto" title: no explicit text is emitted, so the app derives the displayed title from the single series name.
    static Chart.Builder
    Chart.bar()
    A horizontal bar chart: categories up the side, values along the bottom.
    Chart.Builder
    Chart.Builder.barShape(String shape)
    The solid a 3-D bar or column is drawn as — <c:shape>, ECMA-376 Part 1 §21.2.2.177: "box" (the default), "cone", "coneToMax", "cylinder", "pyramid" or "pyramidToMax".
    static Chart.Builder
    Chart.boxWhisker()
    A box & whisker chart: distribution quartiles with outlier whiskers.
    static Chart.Builder
    Chart.bubble()
    A bubble chart; add series with bubbleSeries(java.lang.String, java.lang.String, java.lang.String, java.lang.String) so each bubble has a size.
    Chart.Builder
    Chart.Builder.bubbleSeries(String name, String valuesRef, String categoriesRef, String sizesRef)
    Add a bubble series: a values (Y) range, a categories (X) range and the sizes (Z) range that gives each bubble its area — <c:bubbleSize>, ECMA-376 Part 1 §21.2.2.19.
    Chart.Builder
    Chart.Builder.bubbleSizes(String sizesRef)
    Attaches a bubble-size (Z) range to the series most recently added — the counterpart of pointFill(int, io.keikai.axyra.sheets.style.Color) for a series that was added with one of the plain series(...) overloads.
    Chart.Builder
    Chart.Builder.categoryAxisTitle(String title)
    Sets the category (X) axis title; null sets none.
    Chart.Builder
    Chart.Builder.categoryAxisVisible(boolean visible)
    Shows or hides the category (X) axis; shown by default (ECMA-376 §21.2.2.16 catAx).
    Chart.Builder
    Chart.Builder.chartAreaBorder(Color color)
    Sets the chart-area border color.
    Chart.Builder
    Chart.Builder.chartAreaFill(Color fill)
    Chart-area fill color (ECMA-376 §21.2.2.198 <c:spPr> on the chart space).
    Chart.Builder
    Chart.Builder.chartAreaNoBorder()
    Suppress the chart-area frame (<a:ln><a:noFill/></a:ln>).
    Chart.Builder
    Chart.Builder.chartAreaNoFill()
    Make the chart-area background explicitly TRANSPARENT (<a:noFill/>, ECMA-376 §20.1.8.44) so the sheet shows through — distinct from leaving the fill unset, which renders as the application-default opaque white.
    Chart.Builder
    Chart.Builder.clearSeries()
    Drop every series this builder currently holds.
    static Chart.Builder
    Chart.column()
    A vertical clustered column chart.
    static Chart.Builder
    Chart.combo()
    A combination chart: one plot holding column, line, area, horizontal bar and scatter series together (ECMA-376 Part 1 §21.2.2.145, one <c:plotArea> with several plot groups).
    Chart.Builder
    Chart.Builder.dataLabels(DataLabels labels)
    Attach data labels to the most recently added series.
    static Chart.Builder
    Chart.doughnut()
    A doughnut chart; set the hole with holeSize(int).
    Chart.Builder
    Chart.Builder.errorBars(ErrorBars errorBars)
    Attach error bars to the most recently added series.
    Chart.Builder
    Chart.Builder.extendedApparatus(String chartExBase64, String colorsBase64, String styleBase64)
    Carry the byte-exact apparatus of a modern extended (cx:) chart — the chartEx part plus its chartColorStyle / chartStyle parts, each base64-encoded — so a re-authored waterfall/funnel/… re-emits the complete part set Excel requires to open the file.
    static Chart.Builder
    Chart.funnel()
    A funnel chart: values as progressively narrowing stages.
    Chart.Builder
    Chart.Builder.gapWidth(int percent)
    Sets the gap between bar or column clusters, as a percentage of one bar's width (0–500).
    Chart.Builder
    Chart.Builder.grouping(String grouping)
    Bar/column/area/line grouping: "clustered" / "stacked" / "percentStacked" / "standard" (default "clustered").
    static Chart.Builder
    Chart.histogram()
    A histogram chart: values bucketed into frequency bins.
    Chart.Builder
    Chart.Builder.holeSize(int percent)
    Sets the doughnut hole size as a percentage of the outer radius; 50 when not set.
    Chart.Builder
    Chart.Builder.legend(LegendPosition position)
    Sets the legend placement.
    Chart.Builder
    Chart.Builder.legendLayout(double x, double y, double w, double h)
    Position the legend at an explicit rectangle in chart-relative fractions (x/y top-left, w/h size, all in [0, 1]) — a manual legend layout.
    Chart.Builder
    Chart.Builder.legendVisible(boolean visible)
    Shows or hides the legend without changing its position.
    static Chart.Builder
    Chart.line()
    A line chart.
    static Chart.Builder
    Chart.map()
    A filled-region map chart: geographic regions colored by value.
    static Chart.Builder
    Chart.of(String type)
    A chart of any supported type token: column, bar, line, pie, area, scatter, doughnut, radar, bubble, surface, stock, combo, waterfall, histogram, funnel, treemap, sunburst, boxWhisker, pareto, map.
    Chart.Builder
    Chart.Builder.overlap(int percent)
    Sets how much bars in one cluster overlap, as a percentage from -100 (a full bar-width gap) to 100 (full overlap).
    static Chart.Builder
    Chart.pareto()
    A pareto chart: sorted histogram with a cumulative-percentage line.
    static Chart.Builder
    Chart.pie()
    A pie chart; Excel draws only the first series.
    Chart.Builder
    Chart.Builder.plotAreaBorder(Color color)
    Sets the plot-area border color.
    Chart.Builder
    Chart.Builder.plotAreaFill(Color fill)
    Sets the plot-area fill color.
    Chart.Builder
    Chart.Builder.plotAreaLayout(double x, double y, double w, double h)
    Position the inner plot area at an explicit rectangle in chart-relative fractions (ECMA-376 §21.2.2.88 manualLayout): x/y are the top-left corner and w/h the size, all in [0, 1].
    Chart.Builder
    Chart.Builder.plotAreaNoBorder()
    Suppress the plot-area frame (<a:ln><a:noFill/></a:ln>).
    Chart.Builder
    Chart.Builder.plotAreaNoFill()
    Make the plot-area background explicitly transparent (mirrors chartAreaNoFill()).
    Chart.Builder
    Chart.Builder.pointExplosion(int pointIndex, int percent)
    Explode the pie/doughnut slice at pointIndex outward by percent of the radius (ECMA-376 §21.2.2.62 dPt/explosion) on the most recently added series.
    Chart.Builder
    Chart.Builder.pointFill(int pointIndex, Color fill)
    Override the fill color of one data point (pie slice / bar) on the most recently added series (ECMA-376 §21.2.2.52 dPt).
    Chart.Builder
    Chart.Builder.pointLabel(int pointIndex, String text)
    Give one point of the most recently added series a label of its own (ECMA-376 §21.2.2.47 dLbl) — a caption in place of the value the rest of the series shows.
    Chart.Builder
    Chart.Builder.pointLabelHidden(int pointIndex, boolean hidden)
    Hide the label of one point while the rest of the series keeps its own (<c:dLbl><c:delete val="1"/>).
    static Chart.Builder
    Chart.radar()
    A radar chart.
    static Chart.Builder
    Chart.scatter()
    An XY scatter chart; each series' categoriesRef holds its X values.
    Chart.Builder
    Chart.Builder.secondaryAxis(boolean on)
    Plot the most recently added series against a secondary value axis (on) — drawn on the right of the plot with its own scale, the way a ratio or a percentage is shown next to amounts — or against the primary one.
    Chart.Builder
    Chart.Builder.series(String name, String valuesRef)
    Adds a data series with no categories range.
    Chart.Builder
    Chart.Builder.series(String name, String valuesRef, String categoriesRef)
    Adds a data series with a categories (labels) range.
    Chart.Builder
    Chart.Builder.series(String name, String valuesRef, String categoriesRef, Color fill)
    Adds a data series with a solid fill color.
    Chart.Builder
    Chart.Builder.seriesType(String type)
    The plot type of the most recently added series in a combo chart — the plot group it is drawn in (ECMA-376 Part 1 §21.2.2.145: a <c:barChart>, <c:lineChart>, <c:areaChart> or <c:scatterChart> under the one <c:plotArea>).
    Chart.Builder
    Chart.Builder.showDataLabels(boolean show)
    Turns value labels on every series on or off.
    static Chart.Builder
    Chart.stock()
    A stock chart (high-low-close).
    Chart.Builder
    Chart.Builder.style(int style)
    The chart's built-in style number (<c:style val>).
    static Chart.Builder
    Chart.sunburst()
    A sunburst chart: hierarchical proportions as concentric rings.
    static Chart.Builder
    Chart.surface()
    A surface chart.
    Chart.Builder
    Chart.Builder.threeD(boolean on)
    Draws the chart in 3-D.
    Chart.Builder
    Chart.Builder.title(String title)
    Sets a literal chart title and turns off autoTitle.
    Chart.Builder
    Chart.Builder.titleFormula(String reference)
    Makes the chart title follow a cell instead of a literal string (<c:title><c:tx><c:strRef><c:f>).
    Chart.Builder
    Chart.Builder.titleLayout(double x, double y, double w, double h)
    Position the chart title at an explicit rectangle in chart-relative fractions — a manual title layout.
    Chart.Builder
    Chart.toBuilder()
    A builder pre-loaded with this chart spec, for read–modify–write round trips.
    static Chart.Builder
    Chart.treemap()
    A treemap chart: hierarchical proportions as nested rectangles.
    Chart.Builder
    Chart.Builder.trendline(Trendline trendline)
    Add a trendline to the most recently added series.
    Chart.Builder
    Chart.Builder.type(String type)
    Change the chart family this spec describes, keeping everything else it already carries — the counterpart of Chart.type() on the read–modify–write path, where the family comes from the file and the caller wants a different one.
    Chart.Builder
    Chart.Builder.valueAxisGridlines(boolean on)
    Show or hide the value (Y) axis' major gridlines — the lines across the plot at each major tick (<c:majorGridlines>, ECMA-376 Part 1 §21.2.2).
    Chart.Builder
    Chart.Builder.valueAxisScale(double min, double max)
    Fixes the value (Y) axis to the range [min, max].
    Chart.Builder
    Chart.Builder.valueAxisTitle(String title)
    Sets the value (Y) axis title; null sets none.
    Chart.Builder
    Chart.Builder.valueAxisVisible(boolean visible)
    Shows or hides the value (Y) axis; shown by default (ECMA-376 §21.2.2.226 valAx).
    Chart.Builder
    Chart.Builder.view3D(int rotX, int rotY, int depthPercent)
    Render the chart in 3-D with the given view angles (ECMA-376 §21.2.2.228 view3D): rotX is the elevation and rotY the rotation, both in degrees; depthPercent is the depth as a percentage of the plot height (100 = default).
    static Chart.Builder
    Chart.waterfall()
    A waterfall (bridge) chart: running total with positive/negative steps.