Uses of Class
io.keikai.axyra.sheets.content.Chart.Builder
Packages that use Chart.Builder
-
Uses of Chart.Builder in io.keikai.axyra.sheets.content
Methods in io.keikai.axyra.sheets.content that return Chart.BuilderModifier and TypeMethodDescriptionChart.Builder.anchor(int fromRow, int fromColumn, int toRow, int toColumn) The two-cell anchor rectangle (0-based cells).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.BuilderChart.area()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.BuilderChart.bar()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.BuilderChart.boxWhisker()A box & whisker chart: distribution quartiles with outlier whiskers.static Chart.BuilderChart.bubble()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.bubbleSizes(String sizesRef) Attaches a bubble-size (Z) range to the series most recently added — the counterpart ofpointFill(int, io.keikai.axyra.sheets.style.Color)for a series that was added with one of the plainseries(...)overloads.Chart.Builder.categoryAxisTitle(String title) Category (X) axis title.Chart.Builder.categoryAxisVisible(boolean visible) Show or hide the category (X) axis (ECMA-376 §21.2.2.16 catAx).Chart.Builder.chartAreaBorder(Color color) Chart-area frame (border) line color.Chart.Builder.chartAreaFill(Color fill) Chart-area fill color (ECMA-376 §21.2.2.198<c:spPr>on the chart space).Chart.Builder.chartAreaNoBorder()Suppress the chart-area frame (<a:ln><a:noFill/></a:ln>).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.clearSeries()Drop every series this builder currently holds.static Chart.BuilderChart.column()static Chart.BuilderChart.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.dataLabels(DataLabels labels) Attach data labels to the most recently added series.static Chart.BuilderChart.doughnut()Attach error bars to the most recently added series.Chart.Builder.extendedApparatus(String chartExBase64, String colorsBase64, String styleBase64) Carry the byte-exact apparatus of a modern extended (cx:) chart — thechartExpart plus itschartColorStyle/chartStyleparts, each base64-encoded — so a re-authored waterfall/funnel/… re-emits the complete part set Excel requires to open the file.static Chart.BuilderChart.funnel()A funnel chart: values as progressively narrowing stages.Chart.Builder.gapWidth(int percent) Bar/column gap width as a percentage of bar width (0–500, default 150).Bar/column/area/line grouping:"clustered"/"stacked"/"percentStacked"/"standard"(default"clustered").static Chart.BuilderChart.histogram()A histogram chart: values bucketed into frequency bins.Chart.Builder.holeSize(int percent) Doughnut hole size as a percentage (10–90, default 50).Chart.Builder.legend(LegendPosition position) Legend placement;LegendPosition.NONEhides the legend.Chart.Builder.legendLayout(double x, double y, double w, double h) Position the legend at an explicit rectangle in chart-relative fractions (x/ytop-left,w/hsize, all in[0, 1]) — a manual legend layout.Chart.Builder.legendVisible(boolean visible) Show or hide the legend without changing its position — distinct fromlegend(LegendPosition).static Chart.BuilderChart.line()static Chart.BuilderChart.map()A filled-region map chart: geographic regions colored by value.static Chart.BuilderA 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.overlap(int percent) Bar overlap as a percentage (-100 to 100, default 0).static Chart.BuilderChart.pareto()A pareto chart: sorted histogram with a cumulative-percentage line.static Chart.BuilderChart.pie()Chart.Builder.plotAreaBorder(Color color) Plot-area frame (border) line color.Chart.Builder.plotAreaFill(Color fill) Plot-area fill color.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.88manualLayout):x/yare the top-left corner andw/hthe size, all in[0, 1].Chart.Builder.plotAreaNoBorder()Suppress the plot-area frame (<a:ln><a:noFill/></a:ln>).Chart.Builder.plotAreaNoFill()Make the plot-area background explicitly transparent (mirrorschartAreaNoFill()).Chart.Builder.pointExplosion(int pointIndex, int percent) Explode the pie/doughnut slice atpointIndexoutward bypercentof the radius (ECMA-376 §21.2.2.62dPt/explosion) on the most recently added series.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.pointLabel(int pointIndex, String text) Give one point of the most recently added series a label of its own (ECMA-376 §21.2.2.47dLbl) — a caption in place of the value the rest of the series shows.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.BuilderChart.radar()static Chart.BuilderChart.scatter()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.Add a data series referencing a values range.Add a data series with a categories (labels) range.Add a data series with an explicit fill color.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.showDataLabels(boolean show) Show/hide data labels on the series.static Chart.BuilderChart.stock()A stock chart (high-low-close).Chart.Builder.style(int style) The chart's built-in style number (<c:style val>).static Chart.BuilderChart.sunburst()A sunburst chart: hierarchical proportions as concentric rings.static Chart.BuilderChart.surface()A surface chart.Chart.Builder.threeD(boolean on) Render the chart in 3-D.Chart.Builder.titleFormula(String reference) Make the chart title follow a cell rather than a literal string —<c:title><c:tx><c:strRef><c:f>.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.toBuilder()A builder pre-loaded with this chart spec, for read–modify–write round-trips.static Chart.BuilderChart.treemap()A treemap chart: hierarchical proportions as nested rectangles.Add a trendline to the most recently added series.Change the chart family this spec describes, keeping everything else it already carries — the counterpart ofChart.type()on the read–modify–write path, where the family comes from the file and the caller wants a different one.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.valueAxisScale(double min, double max) Fix the value (Y) axis scale to[min, max].Chart.Builder.valueAxisTitle(String title) Value (Y) axis title.Chart.Builder.valueAxisVisible(boolean visible) Show or hide the value (Y) axis (ECMA-376 §21.2.2.226 valAx).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.228view3D):rotXis the elevation androtYthe rotation, both in degrees;depthPercentis the depth as a percentage of the plot height (100 = default).static Chart.BuilderChart.waterfall()A waterfall (bridge) chart: running total with positive/negative steps.