Menu
SharePoint jQuery Charts

Data Source Settings

Data for charts are taken from data sources. The more graphs you need to show on chart, the more data sources you need to add. Virto JQuery Charts enable users to add data sources of three types – SharePoint list, XML file or SQL database.

Click “Create new data source”.

  1. SharePoint list.

Enter data source name, decide whether to check boxes “Show on chart”, “Show data values on chart” and “Show markers” or not.

Define font size and positions of data labels. For instance, define larger font size in pixels.

Select marker type (diamond, circle, square, x, plus, dash, filled diamond, filled circle, filled square).

Select “SharePoint list” in the list of data source types.

Then select SharePoint site and SharePoint list. Define filtering options, if you need.

Then select source fields with data for X and Y axes, and define color of line. If X axis has datetime format, data aggregation option is available. In this case select aggregation unit (year, month, day, hour, minute) for grouping data.

You can also define values grouping for Y axis of any type that will be applied to shown data (grouping by sum, average, amount, percent or none.

*Note: data aggregation option is available only if grouping is defined. *

Click “Save” to save data source settings.

  1. XML file.

Enter data source name, decide whether to check boxes “Show on chart”, “Show data values on chart” and “Show markers” or not.

Define font size and positions of data labels. For instance, define larger font size in pixels.

Select marker type (diamond, circle, square, x, plus, dash, filled diamond, filled circle, filled square).

Select “XML file” in the list of data source types.

Then define xml file path, xml name spaces, xml data records path. Define X axis properties.

Note: XPath examples can be taken from msdn.microsoft.com *site. *

Then define Y axis properties.

You can also define values grouping for Y axis of any type that will be applied to shown data (grouping by sum, average, amount, percent or none.

*Note: data aggregation option is available only if grouping is defined. *

Click “Save” to save data source settings.

  1. SQL Server.

Enter data source name, decide whether to check boxes “Show on chart”, “Show data values on chart” and “Show markers” or not.

Define font size and positions of data labels. For instance, define larger font size in pixels.

Select marker type (diamond, circle, square, x, plus, dash, filled diamond, filled circle, filled square).

Select “SQL Server” in the list of data source types.

Then enter SQL server, user name and password and click “Browse” to connect to SQL database.

Now select database name, table name and X axis properties from dropdown (available in case of successful connection to SQL server).

You can use query string and define in where clause a value. If in query string is a value defined, it can be pointed both in the conditions and in the query string. When data is requested from the data base, value in square brackets will be changed to the value from query string. This way you can filter displayed data.

Then define Y axis properties (source, values grouping and data aggregation unit).

Define values grouping for Y axis of any type that will be applied to shown data (grouping by sum, average, amount, percent or none.

*Note: data aggregation option is available only if grouping is defined. *

Click “Save” to save data source settings.