Deborah has attended:
No courses
Using null values in chart source data
Hi,
I have tables which use various formula to process daily data over a week. For most of the week part of the table is empty and I use IF and IFERROR statements to place a 0 or "" (null?) value to keep everything looking neat and tidy.
Problem is that we send out line graphs from this data and they look very untidy with a bunch of lines running along the bottom, as happens when the values are set to 0. I have tried setting these values to "" and the chart still takes this as 0. If I simply clear contents from the cells, then the chart will take this as empty and not display a value.
Do you know of a way to pass the equivalent value of an empty cell to a chart via a formula?
RE: Using null values in chart source data
Hello Deborah,
Thank you for your question. Have you got the option to exclude the zero value cells from your chart altogether? This way, they won't show up on the chart at all and you won't have to change formulas or cell contents.
If this is an option, you can use the Select Data button on the Chart Tools - Design ribbon to change the ranges of cells to display on the chart.
If not, please reply so that we can look at other options.
Kind regards
Marius Barnard
Excel Trainer
