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...
Hi, I assume you would like a dynamic chart. I was in the same situation as you and I found out this tutorial: https://trumpexcel.com/dynamic-chart-range/, it basically use Excel Tables or formulas (if you still prefer to maintain the values in a range of cells).
I found the Excel Table method easier to follow, so I went with it:
1. Simply convert your range of values into table
2. Select the wanted cells that contain values
3. Insert your chart
As soon as you key in new value(s) under the last row of the table, it will be automatically included into the table, and also reflected on the chart.
Thank you for your thoughtful reply. Because of how the graphs and data are laid out, however, I cannot convert the data to tables.
thanks,
Kimber