[Manoj Mohan]

@b_juarez,

Glad that you were able to figure out the issue. In order to get UTF-8 characters from the database, you can set CharacterSet to UTF-8 in the connection options as shown in this documentation page.

—–
Manoj Mohan
Team CanvasJS

[Manoj Mohan]

@b_juarez,

It seems to be working fine. Please take a look at this working sample project along with the database.

Also, please take a look at this documentation for more information.

—-
Manoj Mohan
Team CanvasJS

[Manoj Mohan]

Claire Smith,

You can reset the indexLabel to it’s default value (defaults to “” – empty string) by setting indexLabel to null. Please take a look at this JSFiddle.

—-
Manoj Mohan
Team CanvasJS

[Manoj Mohan]

@vijay-sahdev,

Please take a look at this JSFiddle.

—-
Manoj Mohan
Team CanvasJS

[Manoj Mohan]

@driven13,

I would suggest you to use column chart to show the number of searches over axisY and the search term as labels over axisX.

If this doesn’t help you fulfill your requirements, kindly share a pictorial representation or some example of your requirements so that we can understand it better and help you out.

—-
Manoj Mohan
Team CanvasJS

[Manoj Mohan]

@ayanghatak,

Thanks for reporting the use-case. We are looking into it and will get back to you at the earliest.

—-
Manoj Mohan
Team CanvasJS

[Manoj Mohan]

@b_juarez,

It seems to be working fine with SQL Server(v14.0.1000.169) and PHP versions (v7.0+). Kindly check with the PHP v7.0+ as there seems to be an issue with SQL Driver and PHP v5.6. Once connected kindly check whether the data you are receiving from the database is being parsed to the format accepted by CanvasJS ({label: “Apple”, y: 6}) or not.

—–
Manoj Mohan
Team CanvasJS

[Manoj Mohan]

@driven13,

You can use column chart with search value on axisY and search terms as label on axisX as shown in this tutorial.

—–
Manoj Mohan
Team CanvasJS

[Manoj Mohan]

@spider,

You seemed to be creating chart everytime you click on the button. I would suggest you to create chart once, outside graphGenerate method and update the chart within the method. Also kindly confirm whether the y-values are numeric or not.

If this doesn’t help you resolve the issue, kindly share sample project over Google-Drive / Onedrive so that we can run it locally at our end, understand the scenario better and help you out.

——
Manoj Mohan
Team CanvasJS

[Manoj Mohan]

@dish-orderssolutions-ii-com,

In case of range-charts, indexlabels will be shown for both minimum and maximum values. However, you can customize it to show only once by using indexLabelFormatter as shown in this JSFiddle.

—-
Manoj Mohan
Team CanvasJS

[Manoj Mohan]

@shibsankar-jana,

Please refer this article for executing JavaScript inside cron job (where you can render and export chart as image). In order to save chart as image on the server, you would require a headless browser like PhantomJS. Please refer this article for the same.

—–
Manoj Mohan
Team CanvasJS

[Manoj Mohan]

@driven13,

You can set interval for axisY to achieve the above requirements.

——
Manoj Mohan
Team CanvasJS

[Manoj Mohan]

@supriya-amour8gmail-com,

Can you kindly share a sample project over Google-Drive or Onedrive and brief more about your requirements so that we can understand it better and help you out?

—–
Manoj Mohan
Team CanvasJS

[Manoj Mohan]

@jason1028,

Adding exploded property to dataPoints after reading it from the database and parsing it should work fine in this case.

If you are still facing the issue, kindly share a sample project along with sample database over Google-Drive or Onedrive so that we can run it locally at our end, understand the scenario better and help you out.

—-
Manoj Mohan
Team CanvasJS

[Manoj Mohan]

@khanhle,

Sorry, this feature is not available as of now. However, you can change the color of all the legend text using fontColor property of legend.

—–
Manoj Mohan
Team CanvasJS