Spaces:
Running
Running
| <head><meta chartset="utf-8"> | |
| <script src="http://apps.bdimg.com/libs/jquery/2.1.4/jquery.min.js"></script> | |
| <script type="text/javascript" src="../js/util.js"></script> | |
| <script type="text/javascript" src="../.debugTemp/wpsjsrpcsdk.js"></script> | |
| <script src="https://cdn.staticfile.org/Chart.js/3.9.1/chart.js"></script> | |
| </head> | |
| <body> | |
| <div id="fr" style="width:600px;height:500px;margin:auto"> | |
| <canvas id="myChart" width="400" height="300"></canvas> | |
| </div> | |
| <h3>建议直接复制下方数据粘贴到Sheet1表格A1:E1区域，使用时修改数据源区域B1:E1数值即可。</h3> | |
| <table border="1" align="center"><tr><td>数值</td><td>5</td><td>6</td><td>2</td><td>7</td></tr></table> | |
| <script> | |
| wps.ApiEvent.AddApiEventListener('SheetChange',(x,y)=>{if(x.Name=='Sheet1'){fx()}}); | |
| function fx(){ | |
| $("#myChart").remove(); | |
| $("#fr").append('<canvas id="myChart" width="400" height="300"></canvas>'); | |
| var data0=wps.ActiveSheet.Range("B1:E1").Value().flat(); | |
| const ctx = document.getElementById('myChart'); | |
| new Chart(ctx, {type: 'bar', | |
| data: {labels: ['Red', 'Blue', 'Yellow', 'Green'], | |
| datasets: [{label: '# 票数',data: data0, | |
| backgroundColor: ['rgba(255, 99, 132, 0.2)','rgba(54, 162, 235, 0.2)','rgba(255, 206, 86, 0.2)','rgba(75, 192, 192, 0.2)'], | |
| borderColor: ['rgba(255, 99, 132, 1)','rgba(54, 162, 235, 1)','rgba(255, 206, 86, 1)','rgba(75, 192, 192, 1)'], | |
| borderWidth: 1 | |
| }] | |
| }, | |
| options: {scales: {y: {beginAtZero: true}}} | |
| }); | |
| } | |
| </script> | |
| </body> | |