But don’t give up hope! There is a way! And it’s not too difficult, though it’s a little time consuming. You can’t select single axis labels in Excel, so you’ve got to go about it a different way. In other words, instead of adding percentage signs to every y-axis label or putting the phrase “Percentages” in the title or sub-title, she wanted a single percentage sign. I was at a conference earlier this fall and someone asked me whether it’s possible to create an Excel chart where only the first (top) y-axis label has a percentage sign format while the others were just number labels.
