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...
KimberBUse a structured table in stead. Add a month and it will expand. The chart will expand with it.
I don't think the way I have it laid out will work. I have 18 pages of graphs, four to a page, with the data for each to the right in the same spreadsheet. Eventually this will go in the DB and will use PowerBI, but had to do it quickly for now.
One page looks like this (but only print the graphs):
