Forum Discussion
How do I make a line chart ignore empty cells and NOT log then as 0?
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.
- KimberBJan 27, 2022Copper Contributor
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):
- Riny_van_EekelenJan 27, 2022Platinum Contributor
KimberB Not sure I understand the question. How would you like the chart to look like?
- KimberBJan 27, 2022Copper Contributor
I'm sorry. I want it to only plot the three data points for each line right now. Then, as I add rows to the data, plot those too. I know I've done this a million times before, but for some reason, it is not working for me now.
I am selecting 12 rows like this, where 9 are blanks.
I want it to look like this: