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()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()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.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.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.