Chartbuilder | end charting application that facilitates easy creation | Chart library

I'm looking for a way to embed a Charts.Chart to a Google Sheet (but not only, I also want to be able to insert it to other supports such as userform, Google Doc, etc.)

I have the following dataset:

I am trying to code a macro that builds a chart for each of the locations. I have created code that creates a new workbook, names the sheet, can create the first chart for Location 1, but I need the code to then loop back through and do the same for Location 2, Location 3, etc. Here is a sample chart below:

The hard part - Sites (Column A) will change. Some months I may have up to Location 10. I need the code to be dynamic enough to create a chart for each unique Site. As you'll see in the code, I'm creating a new workbook, creating the chart in the old file, and cut/paste into a tab in the new workbook. I then rename the worksheet based on Chart Title. I then need the code to loop back to the beginning and repeat the process for each unique location in Column A.

Here is the code:

Why does I get this error when I close the tab in my web browser and go back to the same URL page again?

Error:

I am using google chart to display pie chart in primefaces.PrimeFaces version is 6.1. Currently the tooltip has absolute value and percentage. i just want to display absolute value. My code is

I'm trying to create an EmbeddedChart in Google Sheets without using Range in my spreadsheet, but using my own values that I've calculated. After searching for hours, I'm not finding the solution. What is the best way to do this ? (To sump up I want to use the EmbeddedChartBuilder class like the ChartBuilder class)

I will like to take data from a spreadsheet "dataSheet" (shared with me as View only) to create a chart and output to my own spreadsheet "sheet".

I use Apps Script to create an embeddedChart and encountered this error: Cannot find method insertChart(EmbeddedChartBuilder).

I have followed Google's guide closely https://developers.google.com/apps-script/reference/spreadsheet/embedded-chart but can't resolve the error.

I have debugged step-by-step and realised the error happens at .insertChart (last line of code).

I'm facing some difficulties while trying to implement 'xAxis clickable' column chart. I'm trying to expose additional Pie charts below my column chart, based on user click on one of the element in xAxis.

The way the first graph is build:

Something I'm writing in Google Apps Script for Google Sheets generates a chart. I'd like to have it generate a power series trendline, however I cannot figure out how to do this in Google Apps Script. I can generate a polynomial or linear trendline, but I cannot figure out how to have it do it as a power series.

I'm trying to build a Histogram chart in Apps script. I am able to set the title and bucket size and get everything else working but no matter what I try I can not get the max and min range of the h-axis to set. Code is attached below, when run the chart just has auto set for both max and min. You will see that I have some code commented out as I have tried a range of different ways and none seem to work.