New answers tagged

0 votes

Google Sheets, coloring a line depending on another column (conditional formatting for lines)

Formula in B2 =MAP(SEQUENCE(ROWS(FILTER(color, LEN(color)>=0))), color, values, LAMBDA(squ, col, val, IF(col=1, IF(AND(OFFSET(col,-1,0)<>1, squ<>1), {val,val}...
  • 2,184
-1 votes
Accepted

How to automatically plot multiple series from values in a column

I did it semi-automatically by inserting my own pivot table: Insert > Pivot Table
0 votes

How to automatically plot multiple series from values in a column

Try an unpivot-repivot transformation. Assuming the data is in Sheet1!A1:C16, choose Insert > Sheet and put this formula in cell A1 of the new sheet: =query( let( table, Sheet1!A1:C16, ...
  • 10.5k
0 votes

Chart labels disappear (stays outside the graph area) Google sheets

An easier way to resolve this is by resizing the vertical axis. Gsheets crops the highest value on the chart, especially if its in the top right, so just resize (increase) the vertical axis by a small ...

Top 50 recent answers are included