Chart Area

You can customize the Chart Area, including the border, color, and font.

<p>Chart area supports the following customization:</p> <ul> <li><strong>Background: color , transparency.</strong></li> <li><strong>Text: font family, font size, color, transparency.</strong></li> <li><strong>Border: color, transparency, width, dash style.</strong></li> </ul> <p>You can customize the chart area using the following code:</p> <pre><code class="hljs js language-js"> <span class="hljs-keyword">var</span> chartArea = chart.chartArea(); chartArea.backColor = <span class="hljs-string">"orange"</span>; chartArea.backColorTransparency = <span class="hljs-number">0.8</span>; chartArea.fontFamily = <span class="hljs-string">"Arial"</span>; chartArea.fontSize = <span class="hljs-number">9</span>; chartArea.color = <span class="hljs-string">"green"</span>; chartArea.transparency = <span class="hljs-number">0.3</span>; chartArea.border.color = <span class="hljs-string">"green"</span>; chartArea.border.transparency = <span class="hljs-number">0.3</span>; chartArea.border.width = <span class="hljs-number">3</span>; chartArea.border.dashStyle = GC.Spread.Sheets.Charts.LineType.dash; chart.chartArea(chartArea); </code></pre>
var spread; window.onload = function () { spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"), { sheetCount: 2 }); initSpread(spread); initEvent(spread); //readSetting(new GC.Spread.Sheets.CellTypes.CheckBoxList()); }; function initSpread(spread) { var sheet = spread.getSheet(0); sheet.suspendPaint(); var dataArray = [ ["", 'Chrome', 'Firefox', 'IE', 'Safari', 'Edge', 'Opera', 'Other'], ["2014", 0.4966, 0.1801, 0.2455, 0.0470, 0.0, 0.0150, 0.0158], ["2015", 0.5689, 0.1560, 0.1652, 0.0529, 0.0158, 0.0220, 0.0192], ["2016", 0.6230, 0.1531, 0.1073, 0.0464, 0.0311, 0.0166, 0.0225], ["2017", 0.6360, 0.1304, 0.0834, 0.0589, 0.0443, 0.0223, 0.0246] ]; sheet.setArray(0, 0, dataArray); var chart = sheet.charts.add('Chart1', GC.Spread.Sheets.Charts.ChartType.lineMarkers, 30, 120, 480, 270, "A1:D5", GC.Spread.Sheets.Charts.RowCol.columns); chart.title({text: "Chart Area Customization"}); var chartArea = chart.chartArea(); chartArea.border.color = "green"; chartArea.border.width = 3; chartArea.fontSize = 9; chartArea.color = "green"; chartArea.backColor = "orange"; chartArea.backColorTransparency = 0.8; chart.chartArea(chartArea); sheet.resumePaint(); }; function initEvent(spread) { spread.bind(GC.Spread.Sheets.Events.FloatingElementSelected, function () { var sheet = spread.getActiveSheet(); var chart = getActiveChart(sheet); if (chart) { readSetting(chart); } }); _getElementById("apply").addEventListener('click', function () { applySetting(); }); }; function readSetting(chart) { var chartArea = chart.chartArea(); _getElementById("backColor").value = chartArea.backColor; _getElementById("backColorTransparency").value = chartArea.backColorTransparency; _getElementById("fontFamily").value = chartArea.fontFamily; _getElementById("fontSize").value = chartArea.fontSize; _getElementById("color").value = chartArea.color; _getElementById("transparency").value = chartArea.transparency; _getElementById("border-color").value = chartArea.border.color; _getElementById("border-transparency").value = chartArea.border.transparency; _getElementById("border-width").value = chartArea.border.width; _getElementById("border-dashStyle").value = chartArea.border.dashStyle; } function applySetting() { var sheet = spread.getActiveSheet(); var chart = getActiveChart(sheet); if (!chart) { return; } var chartArea = { backColor: _getText("backColor"), backColorTransparency: _getFloat("backColorTransparency"), color: _getText("color"), transparency: _getFloat("transparency"), fontFamily: _getText("fontFamily"), fontSize: _getValue("fontSize"), border:{ color: _getText("border-color"), width: _getValue("border-width"), transparency: _getFloat("border-transparency"), dashStyle: _getValue("border-dashStyle") }, } chart.chartArea(chartArea); } function getActiveChart(sheet) { var activeChart = null; sheet.charts.all().forEach(function (chart) { if (chart.isSelected()) { activeChart = chart; } }); return activeChart; } function _getElementById(id) { return document.getElementById(id); } function _geBoolean(id) { return _getElementById(id).checked; } function _getFloat(id) { return parseFloat(_getElementById(id).value); } function _getValue(id) { return parseInt(_getElementById(id).value); } function _getText(id) { return _getElementById(id).value; }
<!doctype html> <html style="height:100%;font-size:14px;"> <head> <meta charset="utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <link rel="stylesheet" type="text/css" href="$DEMOROOT$/en/purejs/node_modules/@grapecity/spread-sheets/styles/gc.spread.sheets.excel2013white.css"> <script src="$DEMOROOT$/en/purejs/node_modules/@grapecity/spread-sheets/dist/gc.spread.sheets.all.min.js" type="text/javascript"></script> <script src="$DEMOROOT$/en/purejs/node_modules/@grapecity/spread-sheets-charts/dist/gc.spread.sheets.charts.min.js" type="text/javascript"></script> <script src="$DEMOROOT$/spread/source/js/license.js" type="text/javascript"></script> <script src="app.js" type="text/javascript"></script> <link rel="stylesheet" type="text/css" href="styles.css"> </head> <body> <div class="sample-tutorial"> <div class="sample-tutorial"> <div id="ss" class="sample-spreadsheets"></div> <div class="options-container"> <p>Change the properties below then press the Set button to apply these changes.</p> <div class="option-row" id=""> <label for="backColor">Back Color</label> <input type="text" id="backColor" value="#FF0000" /> </div> <div class="option-row" id=""> <label for="backColorTransparency">Back Color Transparency</label> <input type="number" id="backColorTransparency" step="0.1" min="0" max="1" value="0.7" /> </div> <div class="option-row" id=""> <label for="fontFamily">Font Family</label> <input type="text" id="fontFamily" value="Calibri" /> </div> <div class="option-row" id=""> <label for="fontSize">Font Size</label> <input type="number" id="fontSize" step="1" min="0" max="100" value="1" /> </div> <div class="option-row" id=""> <label for="color">Color</label> <input type="text" id="color" value="#00FF00" /> </div> <div class="option-row" id=""> <label for="transparency">Transparency</label> <input type="number" id="transparency" step="0.1" min="0" max="1" value="0.7" /> </div> <hr> <div class="option-row" id=""> <label for="border-color">Border Color:</label> <input type="text" id="border-color" value="#00FF00" /> </div> <div class="option-row" id=""> <label for="border-transparency">Border Transparency:</label> <input type="number" id="border-transparency" step="0.1" min="0" max="1" value="1" /> </div> <div class="option-row" id=""> <label for="border-width">Border Width:</label> <input type="number" id="border-width" step="1" min="0" max="100" value="1" /> </div> <div class="option-row" id=""> <label for="border-dashStyle">Border DashStyle:</label> <select id="border-dashStyle"> <option value="0" selected="selected">solid</option> <option value="1">dot</option> <option value="2">dash</option> <option value="3">lgDash</option> <option value="4">dashDot</option> <option value="5">lgDashDot</option> <option value="6">lgDashDotDot</option> <option value="7">sysDash</option> <option value="8">sysDot</option> <option value="9">sysDashDot</option> <option value="10">sysDashDotDot</option> </select> </div> <div class="option-row"> <input type="button" id="apply" value="Set" /> </div> </div> </div> </div> </body> </html>
.sample-tutorial { position: relative; height: 100%; overflow: hidden; } .sample-spreadsheets { width: calc(100% - 280px); height: 100%; overflow: hidden; float: left; } .options-container { float: right; width: 280px; padding: 12px; height: 100%; box-sizing: border-box; background: #fbfbfb; overflow: auto; } .option-row { font-size: 14px; padding: 5px; } .option-row { padding-bottom: 5px; } label { display:inline-block; } input{ padding: 1px 8px; box-sizing: border-box; width: 100%; } select{ width: 100%; } input[type=checkbox] { display: inline-block; width: auto; } body { position: absolute; top: 0; bottom: 0; left: 0; right: 0; }