3

As of today's version of Google Sheets (on Dec 6, 2019), we can do this to make the values appear: Create your pie chart (assuming you know how) Click in the upper right of the chart, on the 3 dots. "Chart editor" will appear on the right. Under "Chart editor", there will be "Setup" and "Customize". Click on "Customize" There should be a selection for "...


3

Yes, it is parameter linewidth. Example : =SPARKLINE(L4:L;{"linewidth"\3}) Reminder on how to construct a =sparkline : =SPARKLINE("range",{"charttype"\"line","xmin"\0,"ymin"\0,"color"\"orange","empty"\"ignore","linewidth"\6}) More on sparkline here.


2

Unfortunately the Combo Chart doesn't support the Treat labels as text for the horizontal axis. The alternative is to use a different chart type like: Area chart Column chart Line chart and maybe others First change the chart type to one that supports the required setting, then uncheck the Treat labels as text checkbox One way to do this Open the chart ...


2

Create a helper column (it can be adjacent to your your data, or anywhere else in your spreadsheet). Make the cell values = "Release Date" values, give the data a header, then format the data as YYYY. If the column isn't adjacent to your data, create the chart without the X-Axis, then edit the Series to include both data sets, and edit the X-Axis to remove ...


1

Assuming that you have the values commencing from "one" in the "periode" column, Edit the chart Select "Customize" Select "Horizontal axis" Check the option "Treat labels as text"


1

Year name =mid(OFFSET(A$1,4*ROWS(A$1:A1)-4,,1),4,4) Value =SUM(OFFSET(B$1,4*ROWS(B$1:B1)-4,,4)) Enter these formula in cell D1 and E1 and copy down for as many years data exists. Logic Both formula rely on the OFFSET and ROWS functions. OFFSET returns a range reference ROWS returns the number of rows in an range. The Year value looks at Column A; it ...


1

You can do it by creating a new filter view and filtering out eggplant Go to menu > Filter views Create new filter view Deselect eggplant OK After creating the filter view, within the chart setting you are given the choice to Include hidden/filtered data


1

With some playing around, I figured out what the aggregate feature does. Basically, the aggregate feature allows you to aggregate all values that share an identical x-axis key. Normally, if you have duplicate x-axis keys, your chart will look something like this, with values having the same key forming vertical lines: (I've increased the width of the ...


1

For problem 1, you can add another tab then sort the data with =SORT here's an old answer on stackoverflow I update your sheet with a "data" tab. With some combination of arrays you can regroup data to sort them and make some clean graphs. I select the data i need between brackets to create an array {Chemistry!B3:C23;Chemistry!D3:E23} Then i sort it ...


1

So basically you just need to know the name of the sheet where your chart is. function updateCHARTtitleOnEdit() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("SHEET_NAME"); var chart = sheet.getCharts()[0];// in my case I had only 1 chart on this sheet chart = chart.modify().setOption('title', "DYNAMIC CHART TITLE" || 'Empty')....


1

The code is mine. Unfortunately, we can't determine if the chart is currently active. Still. Again.


Only top voted, non community-wiki answers of a minimum length are eligible