关于实时图表的问题 [英] Question about Live Chart

问题描述

背景：我目前正在使用Excel进行项目。我能够编写VBA脚本来获取原始数据并创建图表。从数据创建图表并不是直截了当的;脚本中有一些操作。

Background: I am currently working on a project with Excel. I was able to write a VBA script to take raw data and create a chart. The chart is not straight forward to create from the data; there are some manipulation in the script.

问题：我想询问是否有一种方法可以通过脚本来显示原始数据（在数据库或SharePoint中的列表中）关于SharePoint的图表？目标是为用户提供选择特定数据集的选项，他们可以在SharePoint上查看图表
。

Question: I want to ask if there is a way that I can manipulate raw data (in a database or a list in SharePoint) with scripting to display a chart on SharePoint? The goal is to give users an option to select specific data set, and they can view the chart on SharePoint.

- 谢谢你！

-Thank you!

推荐答案

您好，

我们可以将数据存储在SharePoint列表中并启用图表SharePoint 2013中的Web部件（默认情况下存在SharePoint 2010），并按列表数据创建图表。请查看以下文章：

We can store the data in a SharePoint List and enable the chart web part in SharePoint 2013(SharePoint 2010 exists by default), and create chart by list data. Check the articles below:

如何在SharePoint 2013中启用图表Web部件 



http://www.sharepointdiary.com/2014/06/how-to-enable-chart-web-part-in-sharepoint-2013.html#ixzz51CSTXIFf SharePoint
列出VI：显示列表数据的令人兴奋的方式 

https://support.office.com/en-us/article/SharePoint-lists -VI-Exciting-ways-to-display-your-list-data-4f24f5a6-9a82-497e-8965-6b9f98e03a01

或者我们也可以使用JSOM获取列表数据或REST API并使用jQuery Chart Plugin创建图表。

Or we can also get list data using JSOM or REST API and create the chart using jQuery Chart Plugin.

以下文章供您参考：

Google图表的实施在SharePoint 2013中

http://www.c-sharpcorner.com/article/implementation-of-google-charts-in-sharepoint-2013/

可视化使用SharePoint和Google Charts的数据

http： //www.evoketechnologies.com/blog/visualizing-sharepoint-google-charts/

使用JavaScript和REST在SharePoint 2013中构建图表

https://www.cardinalsolutions.com/blog/2013/05/ building_charts_ins

最好的问候，

丹尼斯

这篇关于关于实时图表的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！