Numbers line graph question

Question

Level 1

15 points

Numbers line graph question

Hi Community,

Can you please help me out with this line graph? I'm looking for the solution to remove the downwards line in this graph which I marked in the red box.

Is it possible to only show a line when you don't have the data for the next period yet? So I would like to end the line at its last input (for now €15.000), because the next data/input is €0,00 which looks really annoying.

Does somebody know how to fix this, or knows a work-around for this problem?

Thanks people!

MacBook Air 13″, macOS 11.3

Posted on Sep 12, 2021 3:47 AM

Reply

Answer 1

Top-ranking reply

Badunit

Level 7

30,300 points

Sep 12, 2021 5:27 AM in response to matthijs202

If the last cell is empty or has non-numeric text, it will not plot on the chart. If it is a zero, it will plot as a zero.

If your data is a result of a formula, a usual thing to do is use an IF statement to put a null string "" in the cells when the source data for the formula is not yet there.

A simple example is below where I am charting column B and it relies on numbers in column D. If a cell in column D is blank, I want the result in column B to be "", not 0.

B2 =IF(D2<>"", D2*4, "")

Reply

Numbers line graph question

Similar questions