AMREIN ENGINEERING SharePoint Web Parts   |   Office 365 Web Parts   |   Blog   |   Support   |   Search   |   About us   |   Home  


Sharepoint Web Parts  

2019/SE Modern Web Parts  

Digital Clock Webpart  

Alerts Webpart  

Event Manager Webpart  

Sitemap Webpart  

Stock Chart Webpart  

Stock Quotes Webpart  

Dilbert Webpart  

Mega Menu Webpart  

Quote of the Day Webpart  

Webpart Tabs Webpart  

"Spotlight On.." Webpart  

"Tip of the Day" Webpart  

Lightbox Webpart  

Page HeaderSolution  

Tabs & Accordion Webpart  

Weather Webpart  

Slideshow Webpart  

Currency Rates Webpart  

Media Player Webpart  

YouTube Player Webpart  

Map Chart Webpart  

Org Chart Webpart  

Tiles Webpart  

Chart Webpart  

Google Chart Webpart  

Hero Webpart  

News Tiles Webpart  

Cafeteria Webpart  

RSS Feed Ticker Webpart  

SQL Viewer Webpart  

Google Map Webpart  

Quick Poll Webpart  

Quick Survey Webpart  

Audio Player Webpart  

Geo Mapper Webpart  

SQL Chart Webpart  

Exchange Calendar Webpart  

Exchange Events Webpart  

Call to Action Webpart  

Quick Links Webpart  

Filter Webpart  

Image Rotator Webpart  

Navigator Webpart  

KPI Webpart  

Page Hits Webpart  

Picture Menu Webpart  

Timer Webpart  

Podcast Webpart  

SQL Bullet Graph Webpart  

User Spotlight Webpart  

List View Webpart  

Staff Directory Webpart  

Birthday Reminder Webpart  

News Carousel Webpart  

Team Members Webpart  

Christmas Webpart  

Classifieds Webpart  

Image Menu Carousel Webpart  

Timeline Webpart  

Banner Rotator Webpart  

AZ Index Webpart  

Blog Roll Up Webpart  

Discussion Roll Up Webpart  

Document Roll Up Webpart  

News Roll Up Webpart  

Task Roll Up Webpart  

Calendar Roll Up Webpart  

Quick Form Webpart  

Twitter Webpart  

Upcoming Events Webpart  

Welcome Webpart  

Color Calendar Webpart  

Image Carousel Webpart  

Metro Grid Webpart  

Goal Thermometer Webpart  

Swipe Gallery Webpart  

List Items Webpart  

List Rotator Webpart  

List Search Webpart  

Bullet Graph Webpart  

Accordion & Tabs Bundle  

Accordion List Webpart  

Tabs List Webpart  

Microblog/Chat Webpart  

Toast Notifications  

Vacation Planner Webpart  

Multilevel Tile Webpart  

Inspired Tiles Webpart  

Facebook Timeline Webpart  

File Explorer Webpart  

Zip Creator  

AEWebparts  

Web Part Bundle  

Web Parts by Category  

Microsoft Sharepoint Web Parts

Chart SharePoint Web Part




The Chart Web Part allows to chart data contained in the specified Sharepoint List. The charts are created using Google's public Chart API (see official Google Documentation)

The Web Part can be used with Windows Sharepoint Services V3, MOSS 2007, Sharepoint 2010, Sharepoint 2013, Sharepoint 2016, Sharepoint 2019 and Subscription Edition (both "classic" and "modern" pages).  

The following parameters can be configured:

  • Sharepoint List containing the data to be visualized
  • Search Filters
  • Chart Type:
    • Pie Chart
    • 3D Pie Chart
    • Donut Chart
    • Horizontal Bar Chart
    • Vertical Bar Chart
    • Line Chart
    • Area Chart
    • Horizontal and Vertical Stacked Bars
    • Scatter Chart
  • Chart dimensions
  • Chart Title
  • Chart background colors
  • Chart Legend
  • Interactive Search Filters
  • Web Part Connection for filtering

SharePoint 2019/SE 'Modern' version »

Product Price
Chart Web Part for SP 2010
30 day Evaluation Version
(Release 1.0.53)
Free download..
Chart Web Part for SP 2013
30 day Evaluation Version
(Release 1.0.59)
Free download..
Chart Web Part for SP 2016
30 day Evaluation Version
(Release 1.0.59)
Free download..
Chart Web Part for SP 2019 and SE
30 day Evaluation Version
(Release 1.0.59)
Free download..
Chart Web Part
per Sharepoint WFE License
USD 250.00
Web Part Installation Instructions download..
Deployment Instructions for SP 2019 and SE "modern" pages download..

Installation Instructions:

  1. download the Chart Web Part Installation Instructions (PDF file, see above) 
  2. either install the web part manually or deploy the feature to your server/farm as described in the instructions.
  3. 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).

  4. 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:

      - none
      - Count
      - Sum
      - Group Sum
      - Average

      Examples using the List shown below:



      Example:
      Sum (by Title)

      sums the values (as specified in the Data List Column Name field) and groups the results by the Title column:


      Example:
      Count (by Title)

      counts the number of distinct entries in the Title column:



      Example:
      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):
      Example: TradeDate:MMM-dd

      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:

      ProductName:(%)
    • Chart Type: select the desired chart type:
      - Pie
      - Pie3D
      - Donut
      - Line
      - VerticalBar
      - HorizontalBar
      - Vertical Stacked Bar
      - Horizontal Stacked Bar
      - Area
      - CombinedBarLine (combined vertical bar and line chart)
      - Scatter
      - Bubble
      - Sparkline
       

    • 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):
      - top
      - bottom
      - left
      - right
      - inside
      - none
    • 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:
        @Year<;Price>

      • each dropdown filter can optionally be sorted ascending by adding the "^" suffix as follows:
        @Month^
        and descending (from version 1.1.42):
        @Month
      • each dropdown filter can optionally be preset by adding the preset value as follows:
        @Month=April

      Example:
      @Title;@Month;Price:5



      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:
      Example:
      $Season


    • 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:

User Comments Post a Comment 

Kemal Aydık  
4/11/2019 13:25 
Can this webpart be used on a SP2019 on premise modern page?
Juerg  
4/11/2019 13:52 
Kemal,
yes, the web part is also available for Shareponit 2019 "modern" pages.
Ben  
5/7/2019 18:50 
How do you add additional parameters like in the previous google chart version? For example re-label the data field labels.
Juerg  
5/8/2019 12:51 
Ben,
what exactly do you mean by "re-label the data field labels" ?
Ben  
5/14/2019 18:51 
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.
Juerg  
5/14/2019 20:21 
Ben,
I still do not completely understand.
Can you send a screen shot to [email protected] to illustrate the issue ?
Joseph  
5/22/2019 19:39 
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.
Juerg  
5/23/2019 14:36 
Joseph,
to label the y-axis using percentages, please add the below to the web part's "Options" setting:

axisformat=percent
Joseph  
5/28/2019 18:22 
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?
Juerg  
5/29/2019 11:17 
Joseph,
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.
Chris  
6/7/2019 17:26 
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.
Matt  
6/11/2019 17:04 
I'm curious about displaying the values on the chart as well, instead of the hover callouts. Is that possible?
Andreas  
6/13/2019 15:20 
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?
Juerg  
6/13/2019 18:14 
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:

annotate=1



Please re-download the AE Chart web part and then update the solution.
Juerg  
6/14/2019 15:07 
Andreas,
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.
Agape  
8/23/2019 21:39 
Hi, this webpart looks amazing. Is it possible to have a scatterplot?

Thanks!
Agape
Juerg  
8/25/2019 14:53 
Agape,
we have now added the new „Scatter“ chart type:



Data List Column Name:
x-Axis,y-Axis
(eg. enter the name of the x-Axis and the y-Axis, separated by a comma)

Label List Column Name:
leave empty

Chart Type:
Scatter

If you already installed the web part, please re-download it and then update the solution.
Julio  
9/23/2019 19:30 
How can you make the y-axis show tenths and hundredths instead of just whole numbers?

Thankyou
Juerg  
9/24/2019 12:20 
Julio,
the web part automatically chooses an optimal y-axis grid.
Is this not the case in your configuration ?
If so, can you send a screen shot of the chart to [email protected]  ?
Jazer  
10/4/2019 08:09 
How to sort data values in the graph e.g. descending
Jazer  
10/4/2019 08:11 
Also, if possible to hide not applicable data in the graph.. Thanks so much!
Juerg  
10/4/2019 15:38 
Jazer,
please create a list view with the desired sort order and then enter the view name into the web part’s “View Name” setting.
Juerg  
10/4/2019 15:45 
Jazer,
what exactly do you mean by „not applicable data“ ?
Wyatt  
10/21/2019 15:10 
Can I change the size and font of the Horizontal Axis and Vertical Axis label.
Juerg  
10/21/2019 16:02 
Jon,
it is possible to set the font size of the axes labels by adding the below to the web part’s “Options” setting:

axisLabelFontSize=15

(the above example sets the axis label font size to 15pt).

However, currently the font family is hard-coded to “Arial”.
Would it be important for you to set an alternate font family ?
Tobi  
11/19/2019 15:51 
Hello,

is it possible to move annotations to a different position somehow?
Right now when values are 0/null, the "0" overlaps with real values in some chart types.
Like this: https://i.imgur.com/zNx61DE.png

-Tobi
Juerg  
11/19/2019 17:09 
Tobi,
this issue has now been fixed (eg. the annotations are now suppressed for values being zero).
Please re-download the web part and then update the solution.
Danny   
11/20/2019 19:07 
Is this the AE google chart? (with the bundle). I dont appear to have the 'Aggregation Type' field.

What i am trying to achieve is create a chart that displays the number of documents in a library by split by author field

so X would be author
and Y would be display the number of documents in that library by that particular author

Can you help?
Juerg  
11/20/2019 19:46 
Danny,
please make sure to install the "Chart" web part (the one described on this page as opposed to the "Google Chart" web part).
Please then configure the web part as follows:

List Name: Name of your document library
Label List Column Name: Created By
Aggregation Type: Count
Chart Type: Vertical Bar



Danny  
11/21/2019 14:05 
thanks Juerg.

Following those instructions, the webpart dispays 'Label column error: Created By|1 (Value does not fall within expected range.)

any ideas where i am going wrong?
Juerg  
11/21/2019 18:39 
Danny,
can you temporarily enter

trace=1

into the web part’s „Options“ setting and then send us the additional output generated by the web part for analysis to [email protected] ?
Danny Creighton  
11/24/2019 21:23 
No problem. I have emailed.
Tobi  
11/25/2019 13:32 
On some charts the labels get cut off. (https://i.imgur.com/ltWvt9a.png)
Is the an option to change this?

-Tobi
Juerg  
11/25/2019 14:38 
Tobi,
to make the vertical axis labels visible, please enter a value into the web part’s “Vertical Axis Label” setting (eg. do not leave it empty).
Gary  
11/27/2019 12:22 
Pointing this to a library, and selecting a 'Created By' field as the 'Label List Column Name'

I am getting the error 'data list column not specified or not found'

what am i doing wrong?
Juerg  
11/27/2019 14:33 
Gary,
assuming that you want to display the number of documents created by each user, please make sure to set the "Aggregation Type" web part setting to "Count".
Gary  
11/29/2019 22:16 
Having followed that instruction all the webpart displays is a lot of rows that displays 'Label column error: Created By|1 (Value does not fall within expected range.)

Juerg  
12/2/2019 14:03 
Gary,
in case you specified a list view in the web part's "View Name" setting, please then make sure to include the "Created By" column in your list view.
James Olorunosebi  
12/8/2019 20:54 
Please regarding your charting tool. I have a data I need to represent with the following conditions.

The data exists in a SharePoint List, and there is a column containing when certain software licenses expires.
I want to create an Obsolescence Chart that lets me know THE COUNT of those software that will expire using these conditions.

<=31/12/2010 (Less than or Equal to December 31st 2010)
>=1/1/2011 <=31/12/2013 (Greater than January 1 2010 but less than December 31 2013)
>=1/1/2014 <=31/12/2017 (Greater than January 1 2014 but less than December 31 2017)
>=1/1/2018 <=31/12/2021 (Greater than January 1 2018 but less than December 31 2021)
>=1/1/2022 <=31/12/2025 (Greater than January 1 2022 but less than December 31 2025)
>=1/1/2025 (Greater than or Equal to January 1 2025)

I have created Views that match this requirements. How do I tell the chart to select all 6 views and display the graph in 3D horizontal bar chart?
Juerg  
12/9/2019 11:34 
Hi James,

the Chart web part is not able to chart multiple list views, so you will need to create a calculated column for each date range as for example:

=IF(AND([Expires]>DATE(2011,1,1),[ Expires]<DATE(2013,12,31)),1,0)

Please make sure to set the column data type to “Number”.

Please then configure the web part as shown below by entering your 6 column names, separated by commas:

Data List Column Name:
Range1,Range2, etc..

Label List Column Name:
sum

Aggregation Type:
Sum
James Olorunosebi  
12/9/2019 14:12 
Thanks! Worked like a Dr.Strange sorcery! :-)
Gary  
1/8/2020 15:41 
Having followed your instruction, ensuring the Created by field is stipulated in the libraries view.
The webpart is still displaying an error - displaying numerous row detailing 'Label column error: Created By|1 (Value does not fall within expected range.)

Any ideas please
Juerg  
1/8/2020 16:24 
Gary,
did you make sure to add the "Created By" column to your list view ?

Gary  
1/8/2020 18:11 
Yes, the Created by field is displayed in my libraries view.
Juerg  
1/9/2020 10:48 
Gary,
does the problem go away if you leave the web part's "View Name" setting empty ?
Also, would it be possible to schedule a screen sharing session to troubleshoot the issue ?
Gary  
1/9/2020 18:46 
i get the same issue if i clear the view name i am afraid.

happy to run a screen sharing but i am due to go on leave for the next few weeks so i may have to get one of my colleagues to pick this up
Juerg  
1/9/2020 19:06 
Gary,
can you temporarily enter

trace=1

into the web part’s „Options“ setting and then send us the additional output generated by the web part for analysis to [email protected] ?
Gary  
1/10/2020 10:05 
Juerg

I will get my colleague Danny to do this as i am away from the office now for a couple weeks. Danny will be in touch via email.
Aleks Sh  
2/10/2020 16:26 
Hi
Can we set limit to get number of items from list? I've tried use a list view with 10 items limit, but web-part still show 20 items on chart.
Juerg  
2/10/2020 17:12 
Aleks,
we have now updated the web part so that it honors the list view’s „Item Limit“ setting (when the item limit is set to “Limit the total number of items returned to the specified amount”).

Please re-download the Chart web part and then update the web part solution.
Bei Shen  
3/4/2020 18:21 
Can you tell me what the difference between Chart Web Part for SP 219 (Free) and Chart Web Part (per Sharepoint WFE License)? Thanks.
Juerg  
3/4/2020 18:40 
Bei Shen,
Google disabled support for their Image Chart web service on March 14, 2019, although the service is still available to this date.
We thus released the „AE Chart“ web part as a futureproof replacement.
The "Chart" web part also has more sophisticated features.
ALEX GR  
6/16/2020 10:02 
Hey. Thanks for the app.
There is a question. why you have indicated - for free. Did I get a 30-day version? But there is no information about this? Your other applications have a separate “30 day period”. But there is no such information? How should i be now ?
Juerg  
6/16/2020 14:36 
Alex,
the download actually is a „free“ 30 day evaluation license.
Applying the license key after the 30 days turns the web part into the licensed version.
Yair  
6/21/2020 09:21 
Hi, Can we order the bar chart by the count value of the bars?
i.e after setting a count on a column we want to order the bars to be in descending order. Cat it be done(not from the list views) ?
Thanks
Juerg  
6/22/2020 12:37 
Yair,
we have now added the new "sort" option (to be added to the web part's "Options" setting as eg.

sort=desc

or

sort=asc

to sort the chart data in ascending or descending order.
Please re-download the Chart web part and then update the web part solution.
Curtis Snowden  
7/28/2020 02:25 
Is it possible to have colors tied to specific values for the chart? For example, we have a chart that is Tasks On Schedule. I find that if we have a situation where we only have data that is Not On Schedule, it still displays as blue. It looks like the colors will always be used in order, regardless of what the data actually is. Can we have the chart work so that Not On Schedule will always be displayed in Red, or any other specific color we define?

I tried to use a pipe ("blue|On Schedule,red|Not On Schedule" or "On Schedule|blue,Not On Schedule|red"), but that does not work.
Juerg  
7/28/2020 14:51 
Curtis,
we have now added the option to map specific colors to your data columns via the web part's "Chart Color" setting as illustrated below:

On Schedule=blue,Not On Schedule=red

Please re-download the Chart web part and then update the web part solution.
Curtis  
7/28/2020 18:22 
Thank you very much. Unfortunately, it doesn't appear to be working. With the latest version installed it doesn't give me an error message about incorrect color configuration, but the colors still appear in the order provided regardless of the value. Copying your string to Chart Color exactly still has Not On Schedule appearing as blue. I've double checked my spelling and capitalization and it matches exactly. The field we're charting on is Calculated with a data type returned of Single Line of Text. I'm not sure if that makes a difference or not.
Juerg  
7/28/2020 18:43 
Curtis,
which "Chart Type" are you using ?
Curtis  
7/28/2020 19:06 
Standard Pie Chart, "Pie".
Curtis  
7/28/2020 21:33 
Also, is there any way to display the chart if there is no data? Even some kind of placeholder image or text? The title for the chart is always displayed, but if there doesn't happen to be any data based on our filters, no chart is displayed. This leaves a large empty space.
Juerg  
7/29/2020 12:40 
Curtis,
we have now also added color mapping to the "Pie" chart type.
We also add support to display a message or an image if no chart data is available.
You can override the default "Currently no data" message by adding the below to the web part's "Options" setting:

nodata=your message here

To display an image instead of a text message, please use:

nodata=nodata.gif

Please re-download the Chart web part and then update the web part solution.
Curtis  
7/30/2020 19:04 
Both changes are working in the latest version! Thank you very much for your assistance!
MKirby  
8/14/2020 17:57 
When I use the annotate=1 option I get the count numbers, but they have two decimal places. How can I get them to just show whole numbers? Also, do you have a listing of ALL the options we can use in the options box?
Juerg  
8/14/2020 18:34 
MKirby,
to display just whole numbers please use the below “Options” setting:

annotate=1|labelformat=N0

List of Options:
Please note that multiple options are separated by the “|” pipe character.

labels=none   (suppress the chart labels)
labelformat=Nx   (define the numeric label format)
caml=CAML expression   (define a custom CAML expression for filtering)
header=some text   (define the chart header text)
axisformat=percent   (label the y axis using percentages)
gridcolor=color   (value define the gridlines color)
labelfontsize=nn   (define the label font size in px)
axislabelfontsize=nn   (define the axis label font size in px)
legendlabelfontsize=nn   (define the legend font size in px)
tipvalue=some text   (define the tooltip text)
annotate=1   (enable the chart value annotations)
piehole=nn   (define the piehole size in px for donut charts)
sort=asc/desc   (define the chart value sort order)
trendline=1   (display a chart trendline)
nodata=some text   (display custom text if no chart data is available)
css=some CSS styles   (inject additional CSS styles)
trace=1   (enable debug tracing)
Jay  
8/14/2020 21:43 
Can you please show how to create a stacked vertical bar chart, thanks!
Juerg  
8/17/2020 12:47 
Jay,

- set the "Chart Type" to "Vertical Stacked Bar"
- enter at least 2 list columns (one per data series) into the "Data List Column Name" setting.
- if you intend to sum the values by group, set the "Aggregation Type" to "Group Sum"
Matt  
2/17/2021 22:28 
Hello. How do you force set the label width for horizontal bar? Mine are all squished and unreadable or just a "…". Adjusting the chart size doesn't seem to affect it. Thanks
Juerg  
2/18/2021 13:14 
Matt,
you can make the label area wider by ading the below to the web part's "Options" setting:

chartwidth="60%"

(please choose a suitable percentage between 0 and 100%)
Matt  
2/18/2021 19:43 
Thanks Juerg. That option does adjust the size of the chart within the webpart, but the labels are still condensed and not expanding at any percentage. Is there a label option I need to notate as well?
Juerg  
2/18/2021 19:49 
Matt,
can you send a screenshot illustrating the issue to [email protected] ?
Justine  
4/7/2021 21:19 
Is there a way with the CombinedBarLine graph to have 2 columns show as a bar and the third column show as the line? I can't find how to make this distinction. It is only showing the 1st data column as bar, and the last 2 as line.
Juerg  
4/12/2021 18:39 
Justine,
we have now released the new version which allows you to display the first 2 series as bars and the 3rd series as a line.

Please add the below to the web part’s “Options” setting:

combinedbars=2

Please also re-download the Chart web part and then update the web part solution.
Jacopo  
4/30/2021 10:08 
Hi
it's possible have the value label , on the bar and not at the top of the bar
thanks
Juerg  
4/30/2021 14:34 
Jacopo,
we have now added the „annotate=2“ option (to be added to the web part’s „Options“ setting) to display the annotations inside the bars as opposed to on top.

Please re-download the Chart web part and then update the web part solution.
JAcopo  
5/5/2021 16:52 
Thanks
J Walp  
7/6/2021 18:00 
Is there a way to get the values to display as %? The list settings are set to show as %, but on the graphs they just show as a number. Example: the list shows 50% but the graphs just shows 50.
Juerg  
7/12/2021 14:46 
Justine,
please update to the current version (V1.0.46).
Please then change the "modern" web part's “Configuration” setting by replacing

axisformat=percent

by

options=axisformat=percent
Ami T  
1/3/2022 14:39 
Does the "Search Filter(s)" work on the SharePoint 2019 modern page? If so, what is the configuration?
Juerg  
1/3/2022 14:53 
Ami,
we have now added the new „searchfilter=” web part setting to the modern version.

Example:
searchfilter=@Category

See also the”Search Filters” configuration described on this page.

Please re-download the “Chart” web part and then update the web part solution.
Justine  
6/1/2022 16:50 
Is there a way to display values in a cascading layout from largest values to smallest, similar to a pareto chart?
Juerg  
6/3/2022 14:44 
Justine,
you can sort the bars descending by using the below „Options“ web part setting:

sort=desc
Diana Duro Guerreiro  
7/7/2022 17:37 
Hi,
How can I change de scale to the axis? I need the horizontal axis be beetwen o to 100. Thanks
Juerg  
7/14/2022 12:52 
Diana,
we noticed that there is a bug in the Google Visualization library which prevents a single data point to be properly rendered when using the "sum" aggregation (eg. the y-axis scaling is not starting at zero).

We have now taken care of this issue and you can re-download the “Chart” web part and then update the farm solution.
Lukas  
8/1/2022 22:25 
How can I make it so that all entries that were created on one day are displayed as one day, currently I have many bars with one entry because they were made at a different time.

Juerg  
8/2/2022 13:18 
Lukas,
which "Aggregation Type" are you using ?
Maddy  
8/18/2022 23:19 
Hi, I'm having the same problem as Lukas with the dates and I'm using GroupSum
Juerg  
8/19/2022 15:00 
Maddy,
if you need to sum data grouped by day, but the corresponding date column includes the time, you will need to create a "calculated" column which just displays the date part by using the below formula (referring to the "Created" column in this case):

=TEXT(Created,"yyyy-mm-dd")

and then entering the name of your calculated column into the "Label List Column Name" setting.
Brianna  
2/29/2024 17:45 
Is it possible to change the color of the data based on other values? I have added a calculated column in my list that returns a text value signifying which color it should be. I am only using red and green at the moment, and it's a column called LooseDaysColor.

Something like:
Colors=[LooseDaysColor]
Juerg  
2/29/2024 18:07 
Brianna,
are you referring to the web part's "Chart Color" setting where you specify the colors of the datea series ?
Brianna  
2/29/2024 18:16 
The configuration options available on my site are more like this:
aggregate=GroupSum
legend=bottom
color=black
colors=orange,blue
bgc=white


Though AEChart is the webpart we are using.
Juerg  
2/29/2024 18:30 
Brianna,
can you indicate the schema of your SharePoint list that contains the chart data (in order to understand how your "LooseDaysColor" column relates to the data) ?



 
© 2024 AMREIN ENGINEERING AG
  RSS Feed   
Great stuff!  The Amrein parts have made our intranet a better looking, easier to navigate and more useful site at a reasonable price.  Recommended.

David Meier, Magenic


This web part is available for:
SharePoint 2010
SharePoint 2013
SharePoint 2016
SharePoint 2019
SharePoint SE
SharePoint 2019 'modern'
SharePoint SE 'modern'
Office 365