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...
jayzzone11 Like this?
If so, on the Chart Design ribbon, choose Select Data (or right-click on the line and choose Select Data) and look for the option where you can tell Excel how to treat Hidden and Empty Cells. Choose "Connect data points with a line".
I'm on a Mac right now so it will be different from the above picture on a PC, but it's similar.