FG

Excel chart, how to make a formula produce gaps?

Fresh3 days ago
Mar 15, 202619722 views
Confidence Score0%
0%

Problem

I have a chart in Excel 2007 that is basically just a line graph. Some cells that make up the series data cannot produce a value through their formula, and I'd like the chart to place a gap in that location, but no matter what I do, the fact that there is a formula in there seems to make the series…

Error Output

IF(somecondition; SUM(...); "")
                            ^^-  what to add here, is it possible?

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel chart, how to make a formula produce gaps?

Low Risk

I'd normally say return NA(). However, in a line graph, even if you set the series preferences to leave gaps ("Select data" -> "Hidden and empty cells" -> "Show empty cells as:" -> "Gaps"), the line will just connect continuously to the next availab…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment