Sharepoint Web Parts
Digital Clock Web Part
Stock Chart Web Part
Stock Quotes Web Part
Dilbert Web Part
Quote of the Day Web Part
"Spotlight On.." Web Part
"Tip of the Day" Web Part
Lightbox Web Part
Weather Web Part
Slideshow Web Part
Currency Rates Web Part
Media Player Web Part
YouTube Player Web Part
Map Chart Web Part
Org Chart Web Part
Tiles Web Part
Chart Web Part
Google Chart Web Part
Hero Web Part
News Tiles Web Part
RSS Feed Ticker Web Part
SQL Viewer Web Part
Google Map Web Part
Quick Poll Web Part
Quick Survey Web Part
Audio Player Web Part
Google GeoMapper Web Part
SQL Chart Web Part
Exchange Calendar Web Part
Exchange Events Web Part
Call to Action Web Part
Quick Links Web Part
Filter Web Part
Image Rotator Web Part
Navigator Web Part
KPI Web Part
Page Hits Web Part
Picture Menu Web Part
Timer Web Part
Podcast Web Part
SQL Bullet Graph Web Part
User Spotlight Web Part
List View Web Part
Staff Directory Web Part
Birthday Reminder Web Part
News Carousel Web Part
Team Members Web Part
Classifieds Web Part
Image Menu Carousel Web Part
Timeline Web Part
Banner Rotator Web Part
AZ Index Web Part
Blog Roll Up Web Part
Discussion Roll Up Web Part
Document Roll Up Web Part
News Roll Up Web Part
Task Roll Up Web Part
Calendar Roll Up Web Part
Quick Form Web Part
Twitter Web Part
Upcoming Events Web Part
Welcome Web Part
Color Calendar Web Part
Image Carousel Web Part
Metro Grid Web Part
Goal Thermometer Web Part
Swipe Gallery Web Part
List Rotator Web Part
List Search Web Part
Bullet Graph Web Part
Accordion & Tabs List Bundle
Accordion List Web Part
Tabs List Web Part
Microblog/Chat Web Part
Vacation Planner Web Part
Multilevel Tile Web Part
Inspired Tiles Web Part
Facebook Timeline Web Part
Web Part Support
Web Part Bundle
Microsoft Sharepoint Web Parts
Chart Sharepoint Web Part
- download the Chart Web Part Installation Instructions (PDF file, see above)
- either install the web part manually or deploy the feature to your server/farm as described in the instructions.
- Either adapt an existing Sharepoint List or create a new Sharepoint List to store the data to be charted.
Also optionally define a suitable List View for the List if you want to sort or filter the data in a specific way.
The list should include a
- column to hold the data values to be charted (see Data List Column Name setting below).
The column should be a numeric type (Number or Currency).
You can specify multiple data series by entering multiple List column names separated by commas (as eg. Sales 2018,Sales 2019)
- column to hold the data labels to be used (see Label List Column Name setting below).
- Configure the following Web Part properties in the Web Part Editor "Miscellaneous" pane section as needed:
- Site Name: Enter the name of the site that contains the Sharepoint List containing the data to be charted.
- leave this field empty if the List is in the current site (eg. the Web Part is placed in the same site)
- Enter a "/" character if the List is contained in the top site
- Enter a path if the List is in a subsite of the current site (eg. in the form of "current site/subsite")
- List Name: Enter the desired Sharepoint List containing the data to be charted.
- View Name: Optionally enter the desired List View of the list specified above. A List View allows you to specify specific data filtering and sorting.
Leave this field empty if you want to use the List default view.
- Data List Column Name: enter the Sharepoint list column name of the column(s) containing the data to be charted. You can specify multiple data series by entering multiple List column names separated by commas (as eg. Sales 2018,Sales 2019)
- Label List Column Name: enter the Sharepoint List column name of the column that contains the data labels to be used.
- Aggregation Type: select the desired Aggregation type if you want to aggregate data:
- Group Sum
Examples using the List shown below:
Sum (by Title)
sums the values (as specified in the Data List Column Name field) and groups the results by the Title column:
Count (by Title)
counts the number of distinct entries in the Title column:
Average (by Title)
sums the values (as specified in the Data List Column Name field), counts the number of distinct entries and groups the average by the Title column:
You can append the data value to each label by adding the x placeholder to the "Label List Column Name" (separated by a colon). The placeholder can be surrounded by other characters.
Example: append the data value to the labels, surrounded by parentheses:
If the labels consist of dates, you can append a date formatting string to the column name (separated by a colon):
The following formatting options are available:
d - Numeric day of the month without a leading zero.
dd - Numeric day of the month with a leading zero.
ddd - Abbreviated name of the day of the week.
dddd - Full name of the day of the week.
h - 12 Hour clock, no leading zero.
hh - 12 Hour clock with leading zero.
H - 24 Hour clock, no leading zero.
HH - 24 Hour clock with leading zero.
m - Minutes with no leading zero.
mm - Minutes with leading zero.
M - Numeric month with no leading zero.
MM - Numeric month with a leading zero.
MMM - Abbreviated name of month.
MMMM - Full month name.
t - AM/PM but only the first letter.
tt - AM/PM ( a.m. / p.m.)
y - Year with out century and leading zero.
yy - Year with out century, with leading zero.
yyyy - Year with century.
You can append the data value as a percentage to each label by adding the % placeholder to the "Label List Column Name" (separated by a colon). The placeholder can be surrounded by other characters.
Example: append the data value as a percentage to the labels, surrounded by parentheses:
- Chart Type: select the desired chart type:
- Vertical Stacked Bar
- Horizontal Stacked Bar
- CombinedBarLine (combined vertical bar and line chart)
- Chart Title: enter the desired Chart Title
- Chart Width: enter the desired width of the chart in pixels. Enter "0" to have the web part use the available zone width.
- Chart Height: enter the desired height of the chart in pixels.
- Chart Color: enter the HTML color value(s) or the RGB Hex value(s) of the desired data series color. Specify one value for each data series (the values are separated by commas).
Pie Charts: enter two (or more) colors (separated by commas) to specify the wedge colors.
Separate multiple color values by commas.
- Chart Background Color: enter the HTML color value or the RGB Hex value of the desired background color.
The default value is #FFFFFF (white).
- Chart Font Color: enter the HTML color value or the RGB Hex value of the desired text color.
The default value is black.
- Chart Legend Position: allows to control the placement of the chart legend if you display multiple data series (the chart legend is suppressed if only one data series is displayed)
- Horizontal Axis Label: allows to add an optional x axis label (Bar and Line chart only).
- Vertical Axis Label: allows to add an optional y axis label (Bar and Line chart only).
- Center Chart: horizontally center the chart within the available space.
- Search Filter(s): enter the desired List column name(s) to be used for interactive filtering.
- enter the name(s) of the Sharepoint List column(s) to be filtered.
- enter multiple filters separated by semicolons.
- If you place an "@" ampersand character on front of the filter name, a combo box is used (as opposed to a text input box) which is automatically populated with the available List values.
- The default input box sizes can be overridden by appending a number (separated by a colon) to the filter (number of characters for text boxes, pixels for combo boxes)
- the default filter comparison operator ("contains") can be overridden for numeric values to either specify "greater than", "greater or equal", "less than" or "less or equal" or "equal" by adding either the ">", ">=", "<", "<=" or "==" suffix as follows:
- each dropdown filter can optionally be sorted ascending by adding the "^" suffix as follows:
and descending (from version 1.1.42):
- each dropdown filter can optionally be preset by adding the preset value as follows:
displays the following 3 filter boxes:
You can also connect the Chart Web Part to a Sharepoint Filter Web Part (Connections, Get Field From ...) and then adding the "$" prefix in the configuration field "Search Filter(s)" to the column to be filtered:
- Footer: optionally display a custom Footer text below the chart (you can also embed HTML tags if needed).
- License Key: enter your product license key (as supplied after purchase of the Chart web part license).
Leave this field empty during the 30 day evaluation period.
Please enter a comment below if you have problems with the installation, want to give feedback or have suggestions for improvements:
Technical Support Contact Information
|User Comments|| Post a Comment |
|Kemal Aydık |
|Can this webpart be used on a SP2019 on premise modern page?|
unfortunately not, since the web part is server-based (as opposed being created with the Sharepoint SPFx framework).
|How do you add additional parameters like in the previous google chart version? For example re-label the data field labels.|
what exactly do you mean by "re-label the data field labels" ?
|If my data column name = calValue, but I want the data label on the chart to display as "The Value" how can I do that within the Chart Web part. I was able to do this within the google chart web part in the extra google parameters section.|
I still do not completely understand.
Can you send a screen shot to email@example.com to illustrate the issue ?
|How to we change the labels for the y axis to show as percent instead of decimals? When I change the data label with the :(%) it errors saying column not found. |
to label the y-axis using percentages, please add the below to the web part's "Options" setting:
|Hey Juerg - thanks for the follow-up. That doesnt seem to work for me. It does not update the axis labels. Does the column format need to be percent as well?|
the column format does not need to be percent as well.
However, the "axisformat" option was added with version 1.0.13 on January 17, 2019, so you might need to update the web part if you use an older version.
|Hello and thanks for the great webpart!|
How do you supress the data callouts and add the data value on top of the bar? The ProductName:(x) doesn't appear to work for multiple data list columns.
|I'm curious about displaying the values on the chart as well, instead of the hover callouts. Is that possible?|
|Hey Juerg, as Joseph i had the problem to format the y-axis (vaxis) as percent. Try "axisformat=percent" but no success. I use AE chart Web Part Version 1.0.16. Is there an example or list of the options to use?|
|Chris and Matt,|
we have now added the new “annotate” option to display the chart values on top of the data points. It is enabled by adding the below to the web part’s “Options” setting:
Please re-download the AE Chart web part and then update the solution.
please note that versions prior to V1.0.18 also require to enter a value into the "Vertical Axis Label" in order to honor the "axisformat" option.
|Hi, this webpart looks amazing. Is it possible to have a scatterplot?|
we have now added the new „Scatter“ chart type:
Data List Column Name:
(eg. enter the name of the x-Axis and the y-Axis, separated by a comma)
Label List Column Name:
If you already installed the web part, please re-download it and then update the solution.
If you find that you cannot resolve an issue using the above tools, our Technical Support staff will be ready to handle your technical support needs. You can reach our staff by phone or by email.
Phone: +41 (0)62 823 75 75 (9am - 5pm GMT)
Fax : +41 (0)62 823 75 74
© 2019 AMREIN ENGINEERING AG
|One of the best to have SharePoint add-ons. Especially the support from Juerg is excellent and I would highly recommend "Amrein" for all SharePoint Shops out there.
Vijay Ramisetti, LINCOLN EDUCATIONAL SERVICES
Subscribe to Newsletter
If you want to be kept informed about our new or enhanced Sharepoint web parts, subscribe to our Sharepoint Web Part Newsletter:
You can also subscribe to our Web Part News RSS Feed:
Follow us on Twitter:Web Part News
Free SharePoint "Call to Action" Web Part
The free "Call to Action" web part allows to easily publish a call to action button, including some descriptive text.
The Web Part can be used with Sharepoint 2010, Sharepoint 2013, Sharepoint 2016 and Sharepoint 2019.
The following parameters can be configured:
- Button label
- Title and descriptive text
- Target URL
- Background (color or image to draw the viewers’ attention)
SharePoint Exchange Upcoming Events Web Part
The Exchange Upcoming Events Web Part displays the appointments of the selected Microsoft Exchange mailbox(es) or Exchange public folder calendars as a list.
The Web Part can be used with Windows Sharepoint Services V3, MOSS, Sharepoint 2010, Sharepoint 2013, Sharepoint 2016 and Sharepoint 2019.
The following parameters can be configured:
- daily, weekly and monthly view
- Aggregation: Mailbox Calendars and/or Public Folder calendars to be displayed
- group the list by calendar or date
New Collection of Modern Web Parts
We just published a new collection of over 20 Sharepoint "Modern" SPFx web parts:
- Banner Rotator
- Picture Lightbox
- Spotlight On
- Blog Rollup
- Staff Directory
- News Rollup
- Task Rollup
- List Search
- Upcoming Events
- Geo Mapper
- Quick Links
- Quick Forms
- List Rotator
- Discussion Rollup
- Script Editor
SharePoint Chart Web Part
Since Google will disable support for their Image Chart web service on March 14, 2019, we now announce the new Chart web part which uses the Google Visualization Chart web service.
The AE Chart Web Part can be used with Sharepoint 2010, Sharepoint 2013, Sharepoint 2016 and Sharepoint 2019.
SharePoint Timer Web Part
The AE Timer Web Part has been re-designed and allows to display a countdown timer and/or an “elapsed time” timer. The AE Timer Web Part can be used with Windows Sharepoint Services V3, MOSS 2007, Sharepoint 2010, Sharepoint 2013, Sharepoint 2016 and Sharepoint 2019.