Forum Discussion
How do I make a line chart ignore empty cells and NOT log then as 0?
Hello, I made a line chart and I want it to log a potential of 16 data points, but those data points will be filled in over time so I want the line chart to only graph the real-time data for the num...
I've had this work in the past, but it's not working for me this time around. Do you know if this changed since you posted this reply?
Here's what my graph looks like (ick):
Here's my data (I am selecting 12 rows for each line. They will become populated as the months go by):
KimberB This is not working in 365 for me, either. The data popup has the button, but when you select (or Deselect/Save/Select) it still shows the data points as 0 on the graph. (0.0%, in my case)
Have tried to format the cells to no avail.
For me, the, "Connect Data with Lines" option is dimmed.