I want to plot a table that has numerical and string values in it. I would like to generate a PDF but to professionally display it, I want all my string values (NM, N/A) as is without having the “#” in the front. When I just type NA or NM, excel interprets them as zero values and the graph will have a line going to zero instead of having a gap. How can I keep my text values and ignore on the plot at the same time??

Thanks