How do I create a line graph which ignores zero values?

Fresh3 days ago

Mar 15, 202636443 views

Confidence Score0%

Problem

I want to create a graph showing trends over time, calculated from a formula of various data. However, some data is missing, resulting in zeroes in the calculated data which the chart uses. When plotting this data against as a line graph, it's drawing a line down to the axis, which I don't want. I'…

Error Output

00.0    61.6    39.5    74.6    86.8    72.0    66.5    99.5    85.6    80.6    95.0    122.4
81.0    83.1    88.2    00.0    94.3    60.5    00.0   …

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: How do I create a line graph which ignores zero values?

Low Risk

Create an function to place an empty value in the cell if it is zero. I know this works in Excel, but not sure about OpenOffice. I am about 95% sure though.

Awaiting Verification

Be the first to verify this fix

How do I create a line graph which ignores zero values?

Problem

Error Output

1 Fix

Fix for: How do I create a line graph which ignores zero values?

Environment