![]() ![]() You may think there are a lot of steps to this task, but they are all pretty minor and once you’re done you’ll be ready to combine charts and use scatterplots for a lot of different tasks. All we’re going to do is combine the column chart with four separate scatterplot series and use the names of those scatterplot series to label the y-axis. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |