| Build Number | Database | OS | | :---------: | :--------: | :---------: | | 3530 | MariaDB | Windows Server | I have a chart showing percentages and would like to display the percentages on the Y axis without decimals and with the "%" character. But I can't find the correct format string to do this. If I use the format "%", the number is multiplied by 100 but displayed without the "%" character. If I use the format "p", the number is multiplied by 100 and displayed with % but also with two decimals (for example 12.34%). I also tried "p0", in the assumption that the [Kendo UI number formatting](https://www.telerik.com/kendo-jquery-ui/documentation/globalization/intl/numberformatting) is used. However, while this works fine in a grid, it does not work for the chart. If I could use % to multiply by 100 and then somehow add the % using an escape character, it would also work but it seems that none of the usual escapes or string literals work. Any ideas? The data for the chart is retrieved using a Stored Procedure, which also calculates the percentage. One solution would therefore be to multiply the percentage by 100 in the SP. But I hope that this won't be necessary.

How to format percentages for chart axis?

nhofkes

Build Number	Database	OS
3530	MariaDB	Windows Server

I have a chart showing percentages and would like to display the percentages on the Y axis without decimals and with the “%” character. But I can’t find the correct format string to do this. If I use the format “%”, the number is multiplied by 100 but displayed without the “%” character. If I use the format “p”, the number is multiplied by 100 and displayed with % but also with two decimals (for example 12.34%). I also tried “p0”, in the assumption that the Kendo UI number formatting is used. However, while this works fine in a grid, it does not work for the chart. If I could use % to multiply by 100 and then somehow add the % using an escape character, it would also work but it seems that none of the usual escapes or string literals work.

Any ideas?

The data for the chart is retrieved using a Stored Procedure, which also calculates the percentage. One solution would therefore be to multiply the percentage by 100 in the SP. But I hope that this won’t be necessary.

Jaymer

charts have always been sub-par.
the demo/sample apps make use of them and at surface level they seem to work.
the holy grail of charts (IMHO) has always been the ability to drill down into more data.
was very difficult to do using the built in charts.
there were some improvements, but several years ago.
Did quite a few charts with anycharts after being shown the secret sauce by Mark Bailey. He went onto another product and i kept using this anycharts. I actually got drill down to work nicely on a chart, trapping the click and running StartProcess2 or RunQuery and passing in the element I clicked on.

But can’t help with your issue. Maybe a ways down the road they could improve it after the ReportWriter tweaks.
Popular/expensive dev tools just package in the OpenSource stuff now - like Chart.js

nhofkes

Jaymer Thanks. I don’t have a need to drill down in the chart. I just wanted to have the numbers on the axis correctly displayed.

I have now resorted to the work-around mentioned in my previous post, I multiply the percentages by 100. In the attribute I set the number format as ##0 '%' (note the single quotes around the percentage sign). But in the settings for the chart axis, the display format is ##0% (without the single quotes).