python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - google-sheets

Google Sheets Pie Chart - Display Actual Value Below Label, not in pie chart?

I know I can get the actual value to show up in the pie chart, i.e. on the slice. However I want the percentage in the pie chart (which I can get to show up) since it is more likely to fit in a slice ...
test-img

nrojina0

google-sheets

google-docs

Votes: 0

Answers: 1

Latest Answer

I understand that you want to change your pie graph hiding the percentage shown inside the pie slice. If that is your goal, then you only have to update one chart setting. Follow these steps: Double ...
test-img

Jacques-Guzel Heron

In Google Sheets, how to copy tab to another tab in SAME workbook using Script, if the dimensions of the starting sheet are dynamic?

Background & goal: I'm using multiple Google Sheets that are each an interactive interface for multiple users, with various triggers and functions built in. The problem is that, even with instruct...
test-img

MUNGHOLMI

google-apps-script

google-sheets

copy-paste

Votes: 0

Answers: 1

Latest Answer

function copyFromOneShtToAnother() { const ss = SpreadsheetApp.getActive(); const sh = ss.getSheetByName('Sheet0'); const dsh = ss.getSheetByName('Sheet1'); const srg = sh.getRange(1,1,sh.getL...
test-img

Cooper

google script | I need to calculate the difference between two dates, which have as a parameter a specific data of a column

to explain better, I have the id column and the data column: enter image description here I would like to know if there is a way to calculate the difference in column dates using this patient id as a ...
test-img

Natalia Santis

google-apps-script

google-sheets

Votes: 0

Answers: 1

Latest Answer

I'm guessing you are trying to get the first date of each patient ID as default value. And calculate the date diff of two date and append to 3rd columns as date different. const sheet = SpreadsheetA...
test-img

liquidkat

Update order status if all items in order are complete (i.e. Set first cell value of group of rows have same number and match a value)

I populate a google sheet with customer orders. Each row is an item in an order, so there could be multiple rows for the same order. I would like to use a script that updates an order status (column A...
test-img

rockeypjb

google-apps-script

google-sheets

Votes: 0

Answers: 1

Latest Answer

I believe your goal is as follows. When your sample image is used, you want to replace "A5:A6" with the value of "Ready To Ship". From your following reply, I am providing a ver...
test-img

Tanaike

Posts

Questions

Blogs

Jobs