Forum Discussion

jayzzone11's avatar
jayzzone11
Copper Contributor
Feb 27, 2021

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...
Charting
Excel
office 365
Michael_Morris620's avatar
Michael_Morris620
Copper Contributor
Nov 29, 2023

jayzzone11 usually I populate the cellls to be filled in later with #N/A

 

Excel doesn’t include errors in charts. 

I use this to chart monthly sales through the year.  Months yet to happen get a #N/A. 

Leila gaharani (XCEL PLUS) has a video about this, too. I’ve spelled her name wrong I’m sure. 

mike

  • Mattolson01's avatar
    Mattolson01
    Copper Contributor
    Mar 25, 2024

    Michael_Morris620 

     

    I can validate this, switching from blanks to errors fixed my identical problem. Thanks!

Resources