javascript - Google Sheets Annotated Timeline display exact values? -

I do not know I did some research on y-axis and showing the exact value at the top of the graph, and Found the following:

Display the exact value?

Determines that to save space, display a small, rounded version on top of the graph; False indicates that it may be right-click to view and select a value on the pull-down menu. For example, if set to false, 56.13 km can be displayed as 56123.45.

I do not have to display an exact value, rather than a " pull-down menu rounded version, nor any other settings. That script can be used externally and while creating your graph using Google Script Library, but my data is within a sheet, which means that I am not using a webstick using Google Drive and Values ​​displayed I have given it a little importance until I realized that when I hover over the chart, although the lines go up and down (value for big and small value for respect), the top of the chart The displayed value for more points is given the same value according to the decimal.

I divide the values ​​from 1000 and display them in decimal form with suffix Say that the " units (x1000) " but the effect is still the same, they are rounds for 2 dp

I also tried to change the format of those cells which The values ​​include and nothing happened. Is there a specific way or method to use the " Display Precision Value? in Google Drive? Is there any type of settings I have not missed? I used to use Google Script as well If there is a code that will change the settings of the chart to be fully displayed.

Best regards!

I got the solution since Google Drive provided the exact values There is no way to dictate, or I do not know any method or not, I did what I did Google Script to create a query that pulls data from the sheet. How do I transfer this chart? How can I and I use a local host to display the chart locally on my computer which is a workaround for Google Drive. Used:

   gt; Top & gt; Script type = "text / javascript" src = "https://www.google.com / Jsapi? Autoload = {'modules': [{'name': 'visualization', 'version': '1', 'package': ['annotationchart']}] "& gt; & Lt; / Script & gt; & Lt; Script type = 'text / javascript' & gt; Google.load ('Visualization', '1', {'Package': ['Annotation Chart']}); Google.setOnLoadCallback (drawChart); Function drawChart () {var query = new google.visualization.Query ('URL & amp; gid = 1800788428 and range = B: C'); // Note that the URL stands for the link of the sheet which can be obtained by sharing the document. Query.send (handleQueryResponse); } Function Handle Rescue Response (Response) {If (response.isError ()) {Warning ('Error in Query:' + response.getMessage () + '' + response.getDetailedMessage ()); Return; } Var data = response.getDataTable (); Var chart = New google.visualization.AnnotationChart (document.getElementById ('chart_div')); Var option = {displayAnnotations: true}; Chart.draw (data, options); } & Lt; / Script & gt; & Lt; / Head & gt; & Lt; Body & gt; & Lt; Div id = 'chart_div' style = 'width: 900px; Height: 500px; '& Gt; & Lt; / Div & gt; & Lt; / Body & gt; & Lt; / Html & gt;  

The part of adding the URL to run the query was a bit difficult. Once you publish the document (from the top right corner), you can copy a link from the pop-up, which is basically the same from the browser, but "" in it? Usp = sharing "is an additional additional criteria? Then you tell the query that the" gid "is the part to go to the sheet; the gid number from the browser link in the sharing link In the end, tell the query that by selecting and amp; category = in the end with the desired columns and rows, select which category to choose from, an annotation chart will be prepared, By default displaying exact values . For some reason, if the values ​​are still round, then you can add the following code:

  var option = {displayAnnotations: true displayExactValues: true}; 
 
 
 
 
 
 
 
 
 
 
 
 
 
 For information about creating an annotation chart