Hot answers tagged

5

If you use Excel Web Access Web Part to display the chart, it has an option to auto refresh at regular interval. Check out link below for config options: http://office.microsoft.com/en-us/sharepoint-server-help/excel-web-access-web-part-custom-properties-HA010377893.aspx'


3

I guess your question will lead to opinon based. As there are too many tools available to prepare Charts. As you are in SPO, you are going to fetch data using JSOM/REST, so you can integrate ChartJS. There are many other available but some are paid such as JSCharts


2

I'm using the Chart.js, jquery-1.8.3.min.js and my custom .js to display a list in bar, pie, polar and much more. Please take a look here: http://www.chartjs.org/docs/ The custom .js for pie, doughnut and polararea looks in my case like this: // Declare the variables. var sitesProductSalesChart = sitesProductSalesChart || {}; // Array with colors for the ...


2

Not sure about OOTB Chart Web Part. But it is possible with a 3rd party web part, Plumsail Dashboard Designer. You can find a sample with filtering on their demo site.


2

Not saying that this is necessarily the problem, but I have never liked dynamically loading scripts by writing a script tag into the head. So my first inclination would be to get rid of the loadJS function and just load the chart.js script normally: <canvas id="myChart" width="600" height="400"></canvas> <!-- just load the chart.js script ...


2

I found out the solution (after almost 2 months, I was kinda busy). I decided to use $q.all to make the requests, this is a simpler solution instead of "promises" (which I wasn't very sure how it works): <!DOCTYPE html> <html> <head> <script src="jquery-2.1.4.min.js"></script> <script src="angular.js"></script> <...


2

The following Microsoft Article explains about delegation pretty thoroughly. The delegation warning is not something that is linked to your type of account or your subscription but is rather due to the functions used to access the underlying datasets or perhaps the datasets themselves. Keep in mind the delegation warning only applies if you are accessing ...


1

You can use Client Side Open Source Chart API to achieve your functionality. You need to fetch data client side and provide data in array or JSON format to chart function and bang your chart is ready I am providing you and code snippet with Google Charts as Charts API. You can change your list name and Column Names and add this snippet in Content Editor web ...


1

Just tried this....Considering you already have datasource create based on SharePoint List, you can do following. On any screen, From insert tab, select pie chart. https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/use-line-pie-bar-chart Select pie chart, select Items properties and add below formula AddColumns(GroupBy(AddColumns(CustomList, "...


1

You could build custom chart report by google chart. Get data by rest api. My test demo in below thread. https://social.msdn.microsoft.com/Forums/office/en-US/bf8daadd-1ff0-4b19-ac5e-c2b46b4ea88c/error-with-dropdowns-filters-on-google-charts?forum=sharepointdevelopment


1

Yes, just move all the chart code (everything after your //End Data Pull comment) to be inside your onListItemsLoadSuccess function, after the three lines you already have there. Then you will be able to do data: [count, countCa, countCo], Or, for better readability, put all your chart code into another function named, for instance, "drawChart" that takes ...


1

You can create full blown SPFx web part, or quick implementation with CEWP. In both cases the code below remains same. Here are steps for quick CEWP based solution. Create .html file, upload it to SharePoint, point Content Editor Web Part to that HTML file. In that HTML file you have JavaScript code, that loads SharePoint content via REST call, constructs ...


1

If you want to show chart in second webpart also, then remove if(ctx.view === "{3FE32257-65DA-467F-919B-16B742BA932E}") condition from sitesChart.CustomItem If you want to show default list view for the second webpart then do as below //In CustomItem function if(ctx.view === "{3FE32257-65DA-467F-919B-16B742BA932E}"){ //Your code } return RenderItemTemplate(...


1

I have rewritten your code using Rest API and creating object which can be directly fed to the google.visualization.arrayToDataTable. Exclusion of external reference and reduction of If would help you decrease the load time. Also below code help you remove hard coding of status which would help you on longer run. <div id="piechart" style="width:900px;...


1

As long as the provider hosted app renders "valid" HTML, you're good to go. Technology, platform, or whatever that produces the HTML on server side is not relevant.


1

You can use SPServices or SharePointPlus but I suggest you to use SharePointPlus to get data from list. You can use SQL like syntax and it is really easy to use. SharepointPlus ($SP) is a JavaScript library which offers some extended features for SharePoint entirely on client side (requires no server install). $SP will simplify your interactions with ...


1

One option could be to use Excel charts/graph and publish it on SharePoint Online with Excel Services. Check the links below: http://www.dummies.com/how-to/content/how-to-use-sharepoint-online-excel-services.html https://support.office.com/en-us/article/BI-capabilities-in-Excel-and-Office-365-26c0548e-124c-4fd3-aab3-5f64568cb743


1

Plumsail Dashboard Designer supports aggregation and grouping as well. Also, it works in Office 365 and SharePoint on-premises. Not free but good value for price - flexibility, modern view, animation, interactivity, and no coding.


1

You can use the below option : Create Google Chart from SharePoint list: Download the code from http://www.aasoftech.com/download Unzip file: Create-Google-LineChart-WithQueryString.zip Upload all txt file in a document library In a page you want to display the chart add Content Editor Web part Provide the link to one of the chart file located at your ...


1

Javascript can work to accomplish what you're describing, but depending on how robust you need the charting system to be it could become a very serious undertaking (a few months worth of full time work). If you just need something limited to the description in your question (a bar chat that tracks the status of items in a list) you could probably implement ...


1

A similar question was discussed on another thread, and the options were either 1. use JavaScript. (works well, but is tedious to setup), or 2. use a 3rd party chart web part like collabion, nevron, or bamboo solutions which have an auto-refresh feature that refreshes the chart every x seconds.


1

Chart Web Parts aren't available in SharePoint Foundation 2010, they are available in Enterprise version.. For full feature comparison list, please have a look at SharePoint 2010 Feature Comparison (SharePoint Foundation 2010 Vs SharePoint 2010 Standard/Enterprise) However you can use Fusion Chart Web Parts which are free to use CodePlex project and are ...


1

The Enterprise version of SharePoint 2010 has a Chart Web Part under the Business Data category, and is a very simple OOTB solution for this. It can connect to any list on your site and, while it won't automatically refresh if you're viewing it when someone else modifies an item in the connected list, it does generate the chart in realtime whenever you load ...


1

A possible scenario, if you need to modify the data source programmatically, would be to create a custom Web Part that inherits from the Chart Web Part. Then you can set the values using the properties from the base class by overriding the binding methods. I would highly recommend first adding a Chart Web Part using the SP User Interface, configuring it and ...


1

For users of lib_gg_orgchart (http://librerias.logicas.org/lib_gg_orgchart) If you managed to generate the JSON org chart from your source, this will be of interest to you: Version 1.0.0beta1 has just be released. This is the first mayor-number version release. Includes more types of nodes, better rendering, decoupling of the JSON-defined organizational ...


1

What you need to do is use XSLT to write out each list item in javascript object format. You can do this by creating a new page in SharePoint designer and dropping in a DataFormWebPart for the appropriate list. Once that is done, you can choose to override the default XSLT and use your own custom XSLT. Depending on your schema, you will probably need to ...


1

Collabion supports Web Part Connections, so you can filter data based on the query string. You'll need to use the Query String filter web part and connect it to Collabion Charts, it's fairly simple. see their docs for more info. Nevron, has something similar too. Hope this helps.


Only top voted, non community-wiki answers of a minimum length are eligible