Forum Discussion
zero values and charts
I am trying to create a line chart from a conversion table, involving lb to kg, it has five data columns and the rows are in ascending date. when the chart is produced there are zero values due to mi...
Something that never used to work but I think does now (at least with 365) is to detect the zeros or blanks and replace them with #N/A. For me, a suitable formula might be
= LET(
x, CONVERT(+w,"lbm","kg"),
IF(x, x, NA())
)but you will need to perform the conversion twice and nest the formulas.
Otherwise you could filter your data and use a scatter plot or, most labour intensive, interpolate missing points.
Something else to consider is that no longer do old versions of Excel age gracefully. The new versions of Excel render them obsolete, much as they did to the electro-mechanical adding machine or slide rule.