|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.
|How can you make the y-axis show tenths and hundredths instead of just whole numbers?|
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 firstname.lastname@example.org ?
|How to sort data values in the graph e.g. descending|
|Also, if possible to hide not applicable data in the graph.. Thanks so much!|
please create a list view with the desired sort order and then enter the view name into the web part’s “View Name” setting.
what exactly do you mean by „not applicable data“ ?
|Can I change the size and font of the Horizontal Axis and Vertical Axis label. |
it is possible to set the font size of the axes labels by adding the below to the web part’s “Options” setting:
(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 ?
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
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.
|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?
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
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?
can you temporarily enter
into the web part’s „Options“ setting and then send us the additional output generated by the web part for analysis to email@example.com ?
|Danny Creighton |
|No problem. I have emailed.|
|On some charts the labels get cut off. (https://i.imgur.com/ltWvt9a.png)|
Is the an option to change this?
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).
|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?
assuming that you want to disply the number of documents created by each user, please make sure to set the "Aggregation Type" web part setting to "Count".
|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.)|
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 |
|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?
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:
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:
Label List Column Name:
|James Olorunosebi |
|Thanks! Worked like a Dr.Strange sorcery! :-)|