Answer the question
In order to leave comments, you need to log in
How to build a chart (graph) for non-adjacent cells in Google spreadsheets?
Good day.
There is a table like:
| date | number | number |
The first two columns are completely filled and do not cause problems when plotting a graph based on them, but the last one has empty cells and the second graph (on the values of the first and third columns) is obtained with interruptions.
Is it possible to avoid these gaps in the second chart?
Answer the question
In order to leave comments, you need to log in
Hello.
Use the "Functions" section of the main "Settings" - option "show 0"
Please send links to examples goo.gl/ZLO06Q , otherwise it's not always easy to understand what you want to get. Notably, Sheets does not take up space in Google Drive.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question