Thanks, formatting the axis worked. Now for the gaps...my table is automatically populating from other cells. Do you think I could use an IF statement that says basically, if the other cell is not 0 or empty, give me NA (or whatever it is that will make it be blank), and if the other cell is not 0 or empty, give me the value that's in the other cell? If so, how do I tell it to keep the cell BLANK (empty, null, etc.).
Bookmarks