Hi Everyone!
I would like to update the code below to include a variable for the candidate score so that the three annotations: label, arrow and vertical line x values can update with one datapoint. I then want to use the template URL link in googlesheets to dynamically update for each candidate using API Parameters.
I have tried to copy the chart url and update the data at each point, which works in google sheets, but the charts then doesn’t pull through when I create pdfs with Document Studio. In the past I used chart maker’s API link and add the data dynamically and then it worked great.
Chart URL Link