How to build a graph so that it contains only the filled data, and not the entire selected range?

A

Artem Morozov2019-12-22 18:50:10

excel

Artem Morozov, 2019-12-22 18:50:10

There is a table in which every day we fill in the cell of column B. Column C is calculated by the formula: С2=B2+C1.
So that there are no unnecessary values in the dates that have not come in column C, I upgraded the function =ЕСЛИ(B8="";"";B2+C1).
Question. How to build a graph so that it contains only the values filled in the table? But not the entire operating range.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

R

rPman, 2019-12-22
@rPman

Make an additional column with the date, which will use the formula to take the date from column A if there is data in column B or C, and leave it empty if not., select this column in the chart as a data source (for the X axis) and hide it in table so as not to interfere (fill it down with 'with a margin')