I need to make a bar chart of data whose categories are 5 digit zip codes. I cannot find a way to make excel treat the zip codes as categories. I formatted them as text. If I precede the zip codes with a letter, such as z, (so for example, the category is supposed to be 15232 but I use z15232) excel does what I want. But if I try to use the zip codes unaltered as categories, excel treats them as a second series.
Please see attached image. The top chart is correct, except it has the letter z in front of the zip code, which I do not want. Leaving off the z gives the bottom chart, which is not what I want.