N
N
Natascorp2015-03-12 12:01:26
infographics
Natascorp, 2015-03-12 12:01:26

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

1 answer(s)
A
Alexander Ivanov, 2015-03-12
@Natascorp

Hello.
Use the "Functions" section of the main "Settings" - option "show 0"
20de821d52bd49be80aa41f6a4e164ad.gif
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 question

Ask a Question

731 491 924 answers to any question