Hi there - I'm looking for some help for a set of graphs I have. As you can see in the attached file, some of the data points have "N/A" for values because the data isn't available yet, and the chart brings the points all the way down to the 0. Is there a way to change this?
I know I can change the area of cells of data it shows, but I have about 8 of these reports to do frequently and changing all the charts would take quite a while, I'm looking for something more automated.
Please help if you can!