It’s not possible to selectively zoom/pan based on a specific axis. However, this JSFiddle shows the nearest possible working solution using rangeChanging event.
When the axisYType is set to secondary, adding striplines to secondary Y-axis (axisY2) should work fine. Please take a look at this updated JSFiddle. Also refer documentation for more customization options available.
Please download the sample project from this link. An instructions.txt file has been included for your convenience with instructions to set up the project and get the charts running.
Sorry, there is no feature built-in to add missing datapoints. CanvasJS just renders the chart with datapoints that you have passed in chart-options and it doesn’t add any extra datapoints. You can do it in backend – as you have mentioned.
You can display y-value of the datapoint in indexlabel. However if you like to show it over axisY, you can use striplines to do so. Please take a look at this JSFiddle.
You can’t run JSP page in JSFiddle but in server like Apache Tomcat or Glassfish. Please refer this tutorial for step to step guidance on setting up environment for JSP. Also refer this article for an example on retrieving data from Oracle database in JSP.
Can you kindly share a sample project along with sample data over Google-Drive or Onedrive so that we can look at your code, understand it better and help you out?
Can you please let us know the server side technology being used by you so that we can understand your scenario better and help you with an appropriate solution.