2

Is there a way to snap charts to the grid?

In my spreadsheet, my chart hangs a little below my table, but I would like the chart to expand/contract with the cells on the left.

If this is an easy answer, I assure you I've spend a decent amount of time searching Google, the documentation, and the spreadsheets themselves

** Alternative answers are welcome

*** Still looking for an answer to this. Even a definite "not possible" would be helpful at this point

Sample Image: Pie Chart Hangs Below Grid

  • Would love to know this, too, but there doesn't seem to be anything like that... – Wouter Lievens Oct 14 '17 at 8:10
1
  • as already anticipated, snapping chart to the grid is not possible
  • charts can be resized and moved around across the whole sheet to millimetre scope
  • position and/or size of charts can't be dynamic
  • maximum precision of placing can be achieved by holding SHIFT key with arrow keys
  • the only truly dynamic in-cell chart is =SPARKLINE() chart (any other chart is overlayed over cells)

1

6

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.